----------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\research\china\decentralization\restat_data\tabdata\dofiles\tab_da
> ta\tabdata6.log
  log type:  text
 opened on:  22 Jul 2016, 09:51:35

. 
. *** Create province identifiers within city05
. use ..\..\data\tabular_data_BJ\generated\us123-census.dta

. keep if year==1982 & cp90==1
(16,529 observations deleted)

. sort city05

. by city05: keep if _n==1
(404 observations deleted)

. keep city05 province_code

. replace province_code = 510000 if province_code==500000
(0 real changes made)

. sort city05

. save xwtemp.dta, replace
(note: file xwtemp.dta not found)
file xwtemp.dta saved

. 
. *********** 1. Build 1990 City Propers based on aggregates ***********
. 
. use ..\..\data\tabular_data_BJ\generated\agg_cp90.dta

. #delimit ;
delimiter now ;
. keep city05 year promoted_ccity unpromoted_ccity a434-a193 aN*
> gdp gdp_sector1 gdp_sector2 gdp_sector3 tot_pop 
> fdi pop gdp_michigan givo area_paved_roads
> ruralpop rurallabor va_sec1 va_sec2
> totemp gdp_py fdi_py givo_py gdp_sect2 gdp_sect3 total_pop kmpr apr givo_soe giv
> o_colt area fixinvest
> ruralpop_fenxian rurallabor_fenxian gdp_fenxian gdp_sector1_fenxian gdp_sector2_
> fenxian
> avgsalary avgsalary_michigan gdp_predf gdp_predc gdp_sect2_predf gdp_sect2_predc
> a101-a452
> c_totalPop c_emp c_f_* c_m_* c_rur_* c_urb_* c_emp_* asset_*;

. #delimit cr
delimiter now cr
. 
. foreach X of varlist a434-gdp_sect2_predf {
  2. rename `X' `X'_cp90a
  3. }

. 
. reshape wide promoted_ccity unpromoted_ccity *_cp90a, i(city05) j(year)
(note: j = 1982 1990 1995 2000 2005 2008 2010)

Data                               long   ->   wide
-----------------------------------------------------------------------------
Number of obs.                     2002   ->     286
Number of variables                 397   ->    2766
j variable (7 values)              year   ->   (dropped)
xij variables:
                         promoted_ccity   ->   promoted_ccity1982 promoted_ccity19
> 90 ... promoted_ccity2010
                       unpromoted_ccity   ->   unpromoted_ccity1982 unpromoted_cci
> ty1990 ... unpromoted_ccity2010
                             a434_cp90a   ->   a434_cp90a1982 a434_cp90a1990 ... a
> 434_cp90a2010
                             a431_cp90a   ->   a431_cp90a1982 a431_cp90a1990 ... a
> 431_cp90a2010
                             a437_cp90a   ->   a437_cp90a1982 a437_cp90a1990 ... a
> 437_cp90a2010
                           aN5006_cp90a   ->   aN5006_cp90a1982 aN5006_cp90a1990 .
> .. aN5006_cp90a2010
                             a446_cp90a   ->   a446_cp90a1982 a446_cp90a1990 ... a
> 446_cp90a2010
                             a449_cp90a   ->   a449_cp90a1982 a449_cp90a1990 ... a
> 449_cp90a2010
                             a451_cp90a   ->   a451_cp90a1982 a451_cp90a1990 ... a
> 451_cp90a2010
                             a381_cp90a   ->   a381_cp90a1982 a381_cp90a1990 ... a
> 381_cp90a2010
                           aN6003_cp90a   ->   aN6003_cp90a1982 aN6003_cp90a1990 .
> .. aN6003_cp90a2010
                           aN6004_cp90a   ->   aN6004_cp90a1982 aN6004_cp90a1990 .
> .. aN6004_cp90a2010
                           aN6005_cp90a   ->   aN6005_cp90a1982 aN6005_cp90a1990 .
> .. aN6005_cp90a2010
                           aN6006_cp90a   ->   aN6006_cp90a1982 aN6006_cp90a1990 .
> .. aN6006_cp90a2010
                           aN6007_cp90a   ->   aN6007_cp90a1982 aN6007_cp90a1990 .
> .. aN6007_cp90a2010
                           aN6008_cp90a   ->   aN6008_cp90a1982 aN6008_cp90a1990 .
> .. aN6008_cp90a2010
                           aN6009_cp90a   ->   aN6009_cp90a1982 aN6009_cp90a1990 .
> .. aN6009_cp90a2010
                           aN6010_cp90a   ->   aN6010_cp90a1982 aN6010_cp90a1990 .
> .. aN6010_cp90a2010
                           aN6011_cp90a   ->   aN6011_cp90a1982 aN6011_cp90a1990 .
> .. aN6011_cp90a2010
                           aN6012_cp90a   ->   aN6012_cp90a1982 aN6012_cp90a1990 .
> .. aN6012_cp90a2010
                           aN6013_cp90a   ->   aN6013_cp90a1982 aN6013_cp90a1990 .
> .. aN6013_cp90a2010
                           aN6014_cp90a   ->   aN6014_cp90a1982 aN6014_cp90a1990 .
> .. aN6014_cp90a2010
                           aN6015_cp90a   ->   aN6015_cp90a1982 aN6015_cp90a1990 .
> .. aN6015_cp90a2010
                           aN6016_cp90a   ->   aN6016_cp90a1982 aN6016_cp90a1990 .
> .. aN6016_cp90a2010
                           aN6017_cp90a   ->   aN6017_cp90a1982 aN6017_cp90a1990 .
> .. aN6017_cp90a2010
                           aN6018_cp90a   ->   aN6018_cp90a1982 aN6018_cp90a1990 .
> .. aN6018_cp90a2010
                           aN6019_cp90a   ->   aN6019_cp90a1982 aN6019_cp90a1990 .
> .. aN6019_cp90a2010
                           aN6020_cp90a   ->   aN6020_cp90a1982 aN6020_cp90a1990 .
> .. aN6020_cp90a2010
                           aN6021_cp90a   ->   aN6021_cp90a1982 aN6021_cp90a1990 .
> .. aN6021_cp90a2010
                           aN6022_cp90a   ->   aN6022_cp90a1982 aN6022_cp90a1990 .
> .. aN6022_cp90a2010
                             a102_cp90a   ->   a102_cp90a1982 a102_cp90a1990 ... a
> 102_cp90a2010
                             a103_cp90a   ->   a103_cp90a1982 a103_cp90a1990 ... a
> 103_cp90a2010
                             a104_cp90a   ->   a104_cp90a1982 a104_cp90a1990 ... a
> 104_cp90a2010
                             a117_cp90a   ->   a117_cp90a1982 a117_cp90a1990 ... a
> 117_cp90a2010
                             a120_cp90a   ->   a120_cp90a1982 a120_cp90a1990 ... a
> 120_cp90a2010
                             a188_cp90a   ->   a188_cp90a1982 a188_cp90a1990 ... a
> 188_cp90a2010
                             a189_cp90a   ->   a189_cp90a1982 a189_cp90a1990 ... a
> 189_cp90a2010
                             a191_cp90a   ->   a191_cp90a1982 a191_cp90a1990 ... a
> 191_cp90a2010
                             a192_cp90a   ->   a192_cp90a1982 a192_cp90a1990 ... a
> 192_cp90a2010
                             a194_cp90a   ->   a194_cp90a1982 a194_cp90a1990 ... a
> 194_cp90a2010
                             a195_cp90a   ->   a195_cp90a1982 a195_cp90a1990 ... a
> 195_cp90a2010
                           aN3012_cp90a   ->   aN3012_cp90a1982 aN3012_cp90a1990 .
> .. aN3012_cp90a2010
                           aN3013_cp90a   ->   aN3013_cp90a1982 aN3013_cp90a1990 .
> .. aN3013_cp90a2010
                           aN3014_cp90a   ->   aN3014_cp90a1982 aN3014_cp90a1990 .
> .. aN3014_cp90a2010
                             a280_cp90a   ->   a280_cp90a1982 a280_cp90a1990 ... a
> 280_cp90a2010
                             a281_cp90a   ->   a281_cp90a1982 a281_cp90a1990 ... a
> 281_cp90a2010
                             a277_cp90a   ->   a277_cp90a1982 a277_cp90a1990 ... a
> 277_cp90a2010
                             a278_cp90a   ->   a278_cp90a1982 a278_cp90a1990 ... a
> 278_cp90a2010
                         a271_274_cp90a   ->   a271_274_cp90a1982 a271_274_cp90a19
> 90 ... a271_274_cp90a2010
                         a272_275_cp90a   ->   a272_275_cp90a1982 a272_275_cp90a19
> 90 ... a272_275_cp90a2010
                             a268_cp90a   ->   a268_cp90a1982 a268_cp90a1990 ... a
> 268_cp90a2010
                             a269_cp90a   ->   a269_cp90a1982 a269_cp90a1990 ... a
> 269_cp90a2010
                             a265_cp90a   ->   a265_cp90a1982 a265_cp90a1990 ... a
> 265_cp90a2010
                             a266_cp90a   ->   a266_cp90a1982 a266_cp90a1990 ... a
> 266_cp90a2010
                           aN4013_cp90a   ->   aN4013_cp90a1982 aN4013_cp90a1990 .
> .. aN4013_cp90a2010
                             a185_cp90a   ->   a185_cp90a1982 a185_cp90a1990 ... a
> 185_cp90a2010
                             a186_cp90a   ->   a186_cp90a1982 a186_cp90a1990 ... a
> 186_cp90a2010
                     aN_m_55older_cp90a   ->   aN_m_55older_cp90a1982 aN_m_55older
> _cp90a1990 ... aN_m_55older_cp90a2010
                     aN_f_55older_cp90a   ->   aN_f_55older_cp90a1982 aN_f_55older
> _cp90a1990 ... aN_f_55older_cp90a2010
                     aN_t_55older_cp90a   ->   aN_t_55older_cp90a1982 aN_t_55older
> _cp90a1990 ... aN_t_55older_cp90a2010
                             a184_cp90a   ->   a184_cp90a1982 a184_cp90a1990 ... a
> 184_cp90a2010
                             a187_cp90a   ->   a187_cp90a1982 a187_cp90a1990 ... a
> 187_cp90a2010
                             a190_cp90a   ->   a190_cp90a1982 a190_cp90a1990 ... a
> 190_cp90a2010
                             a193_cp90a   ->   a193_cp90a1982 a193_cp90a1990 ... a
> 193_cp90a2010
                              gdp_cp90a   ->   gdp_cp90a1982 gdp_cp90a1990 ... gdp
> _cp90a2010
                      gdp_sector1_cp90a   ->   gdp_sector1_cp90a1982 gdp_sector1_c
> p90a1990 ... gdp_sector1_cp90a2010
                      gdp_sector2_cp90a   ->   gdp_sector2_cp90a1982 gdp_sector2_c
> p90a1990 ... gdp_sector2_cp90a2010
                      gdp_sector3_cp90a   ->   gdp_sector3_cp90a1982 gdp_sector3_c
> p90a1990 ... gdp_sector3_cp90a2010
                          tot_pop_cp90a   ->   tot_pop_cp90a1982 tot_pop_cp90a1990
>  ... tot_pop_cp90a2010
                              fdi_cp90a   ->   fdi_cp90a1982 fdi_cp90a1990 ... fdi
> _cp90a2010
                              pop_cp90a   ->   pop_cp90a1982 pop_cp90a1990 ... pop
> _cp90a2010
                     gdp_michigan_cp90a   ->   gdp_michigan_cp90a1982 gdp_michigan
> _cp90a1990 ... gdp_michigan_cp90a2010
                             givo_cp90a   ->   givo_cp90a1982 givo_cp90a1990 ... g
> ivo_cp90a2010
               avgsalary_michigan_cp90a   ->   avgsalary_michigan_cp90a1982 avgsal
> ary_michigan_cp90a1990 ... avgsalary_michigan_cp90a2010
                 area_paved_roads_cp90a   ->   area_paved_roads_cp90a1982 area_pav
> ed_roads_cp90a1990 ... area_paved_roads_cp90a2010
                         ruralpop_cp90a   ->   ruralpop_cp90a1982 ruralpop_cp90a19
> 90 ... ruralpop_cp90a2010
                       rurallabor_cp90a   ->   rurallabor_cp90a1982 rurallabor_cp9
> 0a1990 ... rurallabor_cp90a2010
                          va_sec1_cp90a   ->   va_sec1_cp90a1982 va_sec1_cp90a1990
>  ... va_sec1_cp90a2010
                          va_sec2_cp90a   ->   va_sec2_cp90a1982 va_sec2_cp90a1990
>  ... va_sec2_cp90a2010
                           totemp_cp90a   ->   totemp_cp90a1982 totemp_cp90a1990 .
> .. totemp_cp90a2010
                           gdp_py_cp90a   ->   gdp_py_cp90a1982 gdp_py_cp90a1990 .
> .. gdp_py_cp90a2010
                        gdp_sect2_cp90a   ->   gdp_sect2_cp90a1982 gdp_sect2_cp90a
> 1990 ... gdp_sect2_cp90a2010
                        gdp_sect3_cp90a   ->   gdp_sect3_cp90a1982 gdp_sect3_cp90a
> 1990 ... gdp_sect3_cp90a2010
                        total_pop_cp90a   ->   total_pop_cp90a1982 total_pop_cp90a
> 1990 ... total_pop_cp90a2010
                             kmpr_cp90a   ->   kmpr_cp90a1982 kmpr_cp90a1990 ... k
> mpr_cp90a2010
                              apr_cp90a   ->   apr_cp90a1982 apr_cp90a1990 ... apr
> _cp90a2010
                        avgsalary_cp90a   ->   avgsalary_cp90a1982 avgsalary_cp90a
> 1990 ... avgsalary_cp90a2010
                          givo_py_cp90a   ->   givo_py_cp90a1982 givo_py_cp90a1990
>  ... givo_py_cp90a2010
                         givo_soe_cp90a   ->   givo_soe_cp90a1982 givo_soe_cp90a19
> 90 ... givo_soe_cp90a2010
                        givo_colt_cp90a   ->   givo_colt_cp90a1982 givo_colt_cp90a
> 1990 ... givo_colt_cp90a2010
                             area_cp90a   ->   area_cp90a1982 area_cp90a1990 ... a
> rea_cp90a2010
                        fixinvest_cp90a   ->   fixinvest_cp90a1982 fixinvest_cp90a
> 1990 ... fixinvest_cp90a2010
                           fdi_py_cp90a   ->   fdi_py_cp90a1982 fdi_py_cp90a1990 .
> .. fdi_py_cp90a2010
                 ruralpop_fenxian_cp90a   ->   ruralpop_fenxian_cp90a1982 ruralpop
> _fenxian_cp90a1990 ... ruralpop_fenxian_cp90a2010
               rurallabor_fenxian_cp90a   ->   rurallabor_fenxian_cp90a1982 rurall
> abor_fenxian_cp90a1990 ... rurallabor_fenxian_cp90a2010
                      gdp_fenxian_cp90a   ->   gdp_fenxian_cp90a1982 gdp_fenxian_c
> p90a1990 ... gdp_fenxian_cp90a2010
              gdp_sector1_fenxian_cp90a   ->   gdp_sector1_fenxian_cp90a1982 gdp_s
> ector1_fenxian_cp90a1990 ... gdp_sector1_fenxian_cp90a2010
              gdp_sector2_fenxian_cp90a   ->   gdp_sector2_fenxian_cp90a1982 gdp_s
> ector2_fenxian_cp90a1990 ... gdp_sector2_fenxian_cp90a2010
                       asset_g_qz_cp90a   ->   asset_g_qz_cp90a1982 asset_g_qz_cp9
> 0a1990 ... asset_g_qz_cp90a2010
                       asset_n_qz_cp90a   ->   asset_n_qz_cp90a1982 asset_n_qz_cp9
> 0a1990 ... asset_n_qz_cp90a2010
                             a101_cp90a   ->   a101_cp90a1982 a101_cp90a1990 ... a
> 101_cp90a2010
                             a105_cp90a   ->   a105_cp90a1982 a105_cp90a1990 ... a
> 105_cp90a2010
                             a106_cp90a   ->   a106_cp90a1982 a106_cp90a1990 ... a
> 106_cp90a2010
                             a107_cp90a   ->   a107_cp90a1982 a107_cp90a1990 ... a
> 107_cp90a2010
                             a108_cp90a   ->   a108_cp90a1982 a108_cp90a1990 ... a
> 108_cp90a2010
                             a109_cp90a   ->   a109_cp90a1982 a109_cp90a1990 ... a
> 109_cp90a2010
                             a110_cp90a   ->   a110_cp90a1982 a110_cp90a1990 ... a
> 110_cp90a2010
                             a111_cp90a   ->   a111_cp90a1982 a111_cp90a1990 ... a
> 111_cp90a2010
                             a112_cp90a   ->   a112_cp90a1982 a112_cp90a1990 ... a
> 112_cp90a2010
                             a113_cp90a   ->   a113_cp90a1982 a113_cp90a1990 ... a
> 113_cp90a2010
                             a114_cp90a   ->   a114_cp90a1982 a114_cp90a1990 ... a
> 114_cp90a2010
                             a115_cp90a   ->   a115_cp90a1982 a115_cp90a1990 ... a
> 115_cp90a2010
                             a116_cp90a   ->   a116_cp90a1982 a116_cp90a1990 ... a
> 116_cp90a2010
                             a118_cp90a   ->   a118_cp90a1982 a118_cp90a1990 ... a
> 118_cp90a2010
                             a119_cp90a   ->   a119_cp90a1982 a119_cp90a1990 ... a
> 119_cp90a2010
                             a121_cp90a   ->   a121_cp90a1982 a121_cp90a1990 ... a
> 121_cp90a2010
                             a122_cp90a   ->   a122_cp90a1982 a122_cp90a1990 ... a
> 122_cp90a2010
                             a123_cp90a   ->   a123_cp90a1982 a123_cp90a1990 ... a
> 123_cp90a2010
                             a124_cp90a   ->   a124_cp90a1982 a124_cp90a1990 ... a
> 124_cp90a2010
                             a125_cp90a   ->   a125_cp90a1982 a125_cp90a1990 ... a
> 125_cp90a2010
                             a126_cp90a   ->   a126_cp90a1982 a126_cp90a1990 ... a
> 126_cp90a2010
                             a127_cp90a   ->   a127_cp90a1982 a127_cp90a1990 ... a
> 127_cp90a2010
                             a128_cp90a   ->   a128_cp90a1982 a128_cp90a1990 ... a
> 128_cp90a2010
                             a129_cp90a   ->   a129_cp90a1982 a129_cp90a1990 ... a
> 129_cp90a2010
                             a130_cp90a   ->   a130_cp90a1982 a130_cp90a1990 ... a
> 130_cp90a2010
                             a131_cp90a   ->   a131_cp90a1982 a131_cp90a1990 ... a
> 131_cp90a2010
                             a132_cp90a   ->   a132_cp90a1982 a132_cp90a1990 ... a
> 132_cp90a2010
                             a133_cp90a   ->   a133_cp90a1982 a133_cp90a1990 ... a
> 133_cp90a2010
                             a134_cp90a   ->   a134_cp90a1982 a134_cp90a1990 ... a
> 134_cp90a2010
                             a135_cp90a   ->   a135_cp90a1982 a135_cp90a1990 ... a
> 135_cp90a2010
                             a136_cp90a   ->   a136_cp90a1982 a136_cp90a1990 ... a
> 136_cp90a2010
                             a137_cp90a   ->   a137_cp90a1982 a137_cp90a1990 ... a
> 137_cp90a2010
                             a138_cp90a   ->   a138_cp90a1982 a138_cp90a1990 ... a
> 138_cp90a2010
                             a139_cp90a   ->   a139_cp90a1982 a139_cp90a1990 ... a
> 139_cp90a2010
                             a140_cp90a   ->   a140_cp90a1982 a140_cp90a1990 ... a
> 140_cp90a2010
                             a141_cp90a   ->   a141_cp90a1982 a141_cp90a1990 ... a
> 141_cp90a2010
                             a142_cp90a   ->   a142_cp90a1982 a142_cp90a1990 ... a
> 142_cp90a2010
                             a143_cp90a   ->   a143_cp90a1982 a143_cp90a1990 ... a
> 143_cp90a2010
                             a144_cp90a   ->   a144_cp90a1982 a144_cp90a1990 ... a
> 144_cp90a2010
                             a145_cp90a   ->   a145_cp90a1982 a145_cp90a1990 ... a
> 145_cp90a2010
                             a146_cp90a   ->   a146_cp90a1982 a146_cp90a1990 ... a
> 146_cp90a2010
                             a181_cp90a   ->   a181_cp90a1982 a181_cp90a1990 ... a
> 181_cp90a2010
                             a182_cp90a   ->   a182_cp90a1982 a182_cp90a1990 ... a
> 182_cp90a2010
                             a183_cp90a   ->   a183_cp90a1982 a183_cp90a1990 ... a
> 183_cp90a2010
                             a196_cp90a   ->   a196_cp90a1982 a196_cp90a1990 ... a
> 196_cp90a2010
                             a197_cp90a   ->   a197_cp90a1982 a197_cp90a1990 ... a
> 197_cp90a2010
                             a198_cp90a   ->   a198_cp90a1982 a198_cp90a1990 ... a
> 198_cp90a2010
                             a199_cp90a   ->   a199_cp90a1982 a199_cp90a1990 ... a
> 199_cp90a2010
                             a200_cp90a   ->   a200_cp90a1982 a200_cp90a1990 ... a
> 200_cp90a2010
                             a201_cp90a   ->   a201_cp90a1982 a201_cp90a1990 ... a
> 201_cp90a2010
                             a202_cp90a   ->   a202_cp90a1982 a202_cp90a1990 ... a
> 202_cp90a2010
                             a203_cp90a   ->   a203_cp90a1982 a203_cp90a1990 ... a
> 203_cp90a2010
                             a204_cp90a   ->   a204_cp90a1982 a204_cp90a1990 ... a
> 204_cp90a2010
                             a205_cp90a   ->   a205_cp90a1982 a205_cp90a1990 ... a
> 205_cp90a2010
                             a206_cp90a   ->   a206_cp90a1982 a206_cp90a1990 ... a
> 206_cp90a2010
                             a207_cp90a   ->   a207_cp90a1982 a207_cp90a1990 ... a
> 207_cp90a2010
                             a208_cp90a   ->   a208_cp90a1982 a208_cp90a1990 ... a
> 208_cp90a2010
                             a209_cp90a   ->   a209_cp90a1982 a209_cp90a1990 ... a
> 209_cp90a2010
                             a210_cp90a   ->   a210_cp90a1982 a210_cp90a1990 ... a
> 210_cp90a2010
                             a211_cp90a   ->   a211_cp90a1982 a211_cp90a1990 ... a
> 211_cp90a2010
                             a212_cp90a   ->   a212_cp90a1982 a212_cp90a1990 ... a
> 212_cp90a2010
                             a213_cp90a   ->   a213_cp90a1982 a213_cp90a1990 ... a
> 213_cp90a2010
                             a214_cp90a   ->   a214_cp90a1982 a214_cp90a1990 ... a
> 214_cp90a2010
                             a215_cp90a   ->   a215_cp90a1982 a215_cp90a1990 ... a
> 215_cp90a2010
                             a216_cp90a   ->   a216_cp90a1982 a216_cp90a1990 ... a
> 216_cp90a2010
                             a217_cp90a   ->   a217_cp90a1982 a217_cp90a1990 ... a
> 217_cp90a2010
                             a218_cp90a   ->   a218_cp90a1982 a218_cp90a1990 ... a
> 218_cp90a2010
                             a219_cp90a   ->   a219_cp90a1982 a219_cp90a1990 ... a
> 219_cp90a2010
                             a220_cp90a   ->   a220_cp90a1982 a220_cp90a1990 ... a
> 220_cp90a2010
                             a221_cp90a   ->   a221_cp90a1982 a221_cp90a1990 ... a
> 221_cp90a2010
                             a222_cp90a   ->   a222_cp90a1982 a222_cp90a1990 ... a
> 222_cp90a2010
                             a223_cp90a   ->   a223_cp90a1982 a223_cp90a1990 ... a
> 223_cp90a2010
                             a224_cp90a   ->   a224_cp90a1982 a224_cp90a1990 ... a
> 224_cp90a2010
                             a225_cp90a   ->   a225_cp90a1982 a225_cp90a1990 ... a
> 225_cp90a2010
                             a226_cp90a   ->   a226_cp90a1982 a226_cp90a1990 ... a
> 226_cp90a2010
                             a227_cp90a   ->   a227_cp90a1982 a227_cp90a1990 ... a
> 227_cp90a2010
                             a228_cp90a   ->   a228_cp90a1982 a228_cp90a1990 ... a
> 228_cp90a2010
                             a229_cp90a   ->   a229_cp90a1982 a229_cp90a1990 ... a
> 229_cp90a2010
                             a230_cp90a   ->   a230_cp90a1982 a230_cp90a1990 ... a
> 230_cp90a2010
                             a231_cp90a   ->   a231_cp90a1982 a231_cp90a1990 ... a
> 231_cp90a2010
                             a232_cp90a   ->   a232_cp90a1982 a232_cp90a1990 ... a
> 232_cp90a2010
                             a233_cp90a   ->   a233_cp90a1982 a233_cp90a1990 ... a
> 233_cp90a2010
                             a234_cp90a   ->   a234_cp90a1982 a234_cp90a1990 ... a
> 234_cp90a2010
                             a235_cp90a   ->   a235_cp90a1982 a235_cp90a1990 ... a
> 235_cp90a2010
                             a236_cp90a   ->   a236_cp90a1982 a236_cp90a1990 ... a
> 236_cp90a2010
                             a237_cp90a   ->   a237_cp90a1982 a237_cp90a1990 ... a
> 237_cp90a2010
                             a238_cp90a   ->   a238_cp90a1982 a238_cp90a1990 ... a
> 238_cp90a2010
                             a239_cp90a   ->   a239_cp90a1982 a239_cp90a1990 ... a
> 239_cp90a2010
                             a240_cp90a   ->   a240_cp90a1982 a240_cp90a1990 ... a
> 240_cp90a2010
                             a241_cp90a   ->   a241_cp90a1982 a241_cp90a1990 ... a
> 241_cp90a2010
                             a242_cp90a   ->   a242_cp90a1982 a242_cp90a1990 ... a
> 242_cp90a2010
                             a243_cp90a   ->   a243_cp90a1982 a243_cp90a1990 ... a
> 243_cp90a2010
                             a244_cp90a   ->   a244_cp90a1982 a244_cp90a1990 ... a
> 244_cp90a2010
                             a245_cp90a   ->   a245_cp90a1982 a245_cp90a1990 ... a
> 245_cp90a2010
                             a246_cp90a   ->   a246_cp90a1982 a246_cp90a1990 ... a
> 246_cp90a2010
                             a261_cp90a   ->   a261_cp90a1982 a261_cp90a1990 ... a
> 261_cp90a2010
                             a262_cp90a   ->   a262_cp90a1982 a262_cp90a1990 ... a
> 262_cp90a2010
                             a263_cp90a   ->   a263_cp90a1982 a263_cp90a1990 ... a
> 263_cp90a2010
                             a264_cp90a   ->   a264_cp90a1982 a264_cp90a1990 ... a
> 264_cp90a2010
                             a267_cp90a   ->   a267_cp90a1982 a267_cp90a1990 ... a
> 267_cp90a2010
                             a270_cp90a   ->   a270_cp90a1982 a270_cp90a1990 ... a
> 270_cp90a2010
                             a271_cp90a   ->   a271_cp90a1982 a271_cp90a1990 ... a
> 271_cp90a2010
                             a272_cp90a   ->   a272_cp90a1982 a272_cp90a1990 ... a
> 272_cp90a2010
                             a273_cp90a   ->   a273_cp90a1982 a273_cp90a1990 ... a
> 273_cp90a2010
                             a274_cp90a   ->   a274_cp90a1982 a274_cp90a1990 ... a
> 274_cp90a2010
                             a275_cp90a   ->   a275_cp90a1982 a275_cp90a1990 ... a
> 275_cp90a2010
                             a276_cp90a   ->   a276_cp90a1982 a276_cp90a1990 ... a
> 276_cp90a2010
                             a279_cp90a   ->   a279_cp90a1982 a279_cp90a1990 ... a
> 279_cp90a2010
                             a282_cp90a   ->   a282_cp90a1982 a282_cp90a1990 ... a
> 282_cp90a2010
                             a283_cp90a   ->   a283_cp90a1982 a283_cp90a1990 ... a
> 283_cp90a2010
                             a284_cp90a   ->   a284_cp90a1982 a284_cp90a1990 ... a
> 284_cp90a2010
                             a291_cp90a   ->   a291_cp90a1982 a291_cp90a1990 ... a
> 291_cp90a2010
                             a292_cp90a   ->   a292_cp90a1982 a292_cp90a1990 ... a
> 292_cp90a2010
                             a293_cp90a   ->   a293_cp90a1982 a293_cp90a1990 ... a
> 293_cp90a2010
                             a294_cp90a   ->   a294_cp90a1982 a294_cp90a1990 ... a
> 294_cp90a2010
                             a295_cp90a   ->   a295_cp90a1982 a295_cp90a1990 ... a
> 295_cp90a2010
                             a296_cp90a   ->   a296_cp90a1982 a296_cp90a1990 ... a
> 296_cp90a2010
                             a301_cp90a   ->   a301_cp90a1982 a301_cp90a1990 ... a
> 301_cp90a2010
                             a302_cp90a   ->   a302_cp90a1982 a302_cp90a1990 ... a
> 302_cp90a2010
                             a303_cp90a   ->   a303_cp90a1982 a303_cp90a1990 ... a
> 303_cp90a2010
                             a304_cp90a   ->   a304_cp90a1982 a304_cp90a1990 ... a
> 304_cp90a2010
                             a305_cp90a   ->   a305_cp90a1982 a305_cp90a1990 ... a
> 305_cp90a2010
                             a306_cp90a   ->   a306_cp90a1982 a306_cp90a1990 ... a
> 306_cp90a2010
                             a307_cp90a   ->   a307_cp90a1982 a307_cp90a1990 ... a
> 307_cp90a2010
                             a308_cp90a   ->   a308_cp90a1982 a308_cp90a1990 ... a
> 308_cp90a2010
                             a309_cp90a   ->   a309_cp90a1982 a309_cp90a1990 ... a
> 309_cp90a2010
                             a310_cp90a   ->   a310_cp90a1982 a310_cp90a1990 ... a
> 310_cp90a2010
                             a311_cp90a   ->   a311_cp90a1982 a311_cp90a1990 ... a
> 311_cp90a2010
                             a312_cp90a   ->   a312_cp90a1982 a312_cp90a1990 ... a
> 312_cp90a2010
                             a313_cp90a   ->   a313_cp90a1982 a313_cp90a1990 ... a
> 313_cp90a2010
                             a314_cp90a   ->   a314_cp90a1982 a314_cp90a1990 ... a
> 314_cp90a2010
                             a315_cp90a   ->   a315_cp90a1982 a315_cp90a1990 ... a
> 315_cp90a2010
                             a321_cp90a   ->   a321_cp90a1982 a321_cp90a1990 ... a
> 321_cp90a2010
                             a322_cp90a   ->   a322_cp90a1982 a322_cp90a1990 ... a
> 322_cp90a2010
                             a323_cp90a   ->   a323_cp90a1982 a323_cp90a1990 ... a
> 323_cp90a2010
                             a324_cp90a   ->   a324_cp90a1982 a324_cp90a1990 ... a
> 324_cp90a2010
                             a325_cp90a   ->   a325_cp90a1982 a325_cp90a1990 ... a
> 325_cp90a2010
                             a326_cp90a   ->   a326_cp90a1982 a326_cp90a1990 ... a
> 326_cp90a2010
                             a327_cp90a   ->   a327_cp90a1982 a327_cp90a1990 ... a
> 327_cp90a2010
                             a328_cp90a   ->   a328_cp90a1982 a328_cp90a1990 ... a
> 328_cp90a2010
                             a329_cp90a   ->   a329_cp90a1982 a329_cp90a1990 ... a
> 329_cp90a2010
                             a330_cp90a   ->   a330_cp90a1982 a330_cp90a1990 ... a
> 330_cp90a2010
                             a331_cp90a   ->   a331_cp90a1982 a331_cp90a1990 ... a
> 331_cp90a2010
                             a332_cp90a   ->   a332_cp90a1982 a332_cp90a1990 ... a
> 332_cp90a2010
                             a341_cp90a   ->   a341_cp90a1982 a341_cp90a1990 ... a
> 341_cp90a2010
                             a342_cp90a   ->   a342_cp90a1982 a342_cp90a1990 ... a
> 342_cp90a2010
                             a343_cp90a   ->   a343_cp90a1982 a343_cp90a1990 ... a
> 343_cp90a2010
                             a344_cp90a   ->   a344_cp90a1982 a344_cp90a1990 ... a
> 344_cp90a2010
                             a345_cp90a   ->   a345_cp90a1982 a345_cp90a1990 ... a
> 345_cp90a2010
                             a346_cp90a   ->   a346_cp90a1982 a346_cp90a1990 ... a
> 346_cp90a2010
                             a347_cp90a   ->   a347_cp90a1982 a347_cp90a1990 ... a
> 347_cp90a2010
                             a348_cp90a   ->   a348_cp90a1982 a348_cp90a1990 ... a
> 348_cp90a2010
                             a349_cp90a   ->   a349_cp90a1982 a349_cp90a1990 ... a
> 349_cp90a2010
                             a350_cp90a   ->   a350_cp90a1982 a350_cp90a1990 ... a
> 350_cp90a2010
                             a351_cp90a   ->   a351_cp90a1982 a351_cp90a1990 ... a
> 351_cp90a2010
                             a352_cp90a   ->   a352_cp90a1982 a352_cp90a1990 ... a
> 352_cp90a2010
                             a361_cp90a   ->   a361_cp90a1982 a361_cp90a1990 ... a
> 361_cp90a2010
                             a362_cp90a   ->   a362_cp90a1982 a362_cp90a1990 ... a
> 362_cp90a2010
                             a363_cp90a   ->   a363_cp90a1982 a363_cp90a1990 ... a
> 363_cp90a2010
                             a364_cp90a   ->   a364_cp90a1982 a364_cp90a1990 ... a
> 364_cp90a2010
                             a365_cp90a   ->   a365_cp90a1982 a365_cp90a1990 ... a
> 365_cp90a2010
                             a366_cp90a   ->   a366_cp90a1982 a366_cp90a1990 ... a
> 366_cp90a2010
                             a367_cp90a   ->   a367_cp90a1982 a367_cp90a1990 ... a
> 367_cp90a2010
                             a368_cp90a   ->   a368_cp90a1982 a368_cp90a1990 ... a
> 368_cp90a2010
                             a369_cp90a   ->   a369_cp90a1982 a369_cp90a1990 ... a
> 369_cp90a2010
                             a370_cp90a   ->   a370_cp90a1982 a370_cp90a1990 ... a
> 370_cp90a2010
                             a382_cp90a   ->   a382_cp90a1982 a382_cp90a1990 ... a
> 382_cp90a2010
                             a383_cp90a   ->   a383_cp90a1982 a383_cp90a1990 ... a
> 383_cp90a2010
                             a384_cp90a   ->   a384_cp90a1982 a384_cp90a1990 ... a
> 384_cp90a2010
                             a385_cp90a   ->   a385_cp90a1982 a385_cp90a1990 ... a
> 385_cp90a2010
                             a386_cp90a   ->   a386_cp90a1982 a386_cp90a1990 ... a
> 386_cp90a2010
                             a387_cp90a   ->   a387_cp90a1982 a387_cp90a1990 ... a
> 387_cp90a2010
                             a388_cp90a   ->   a388_cp90a1982 a388_cp90a1990 ... a
> 388_cp90a2010
                             a389_cp90a   ->   a389_cp90a1982 a389_cp90a1990 ... a
> 389_cp90a2010
                             a390_cp90a   ->   a390_cp90a1982 a390_cp90a1990 ... a
> 390_cp90a2010
                             a391_cp90a   ->   a391_cp90a1982 a391_cp90a1990 ... a
> 391_cp90a2010
                             a392_cp90a   ->   a392_cp90a1982 a392_cp90a1990 ... a
> 392_cp90a2010
                             a393_cp90a   ->   a393_cp90a1982 a393_cp90a1990 ... a
> 393_cp90a2010
                             a394_cp90a   ->   a394_cp90a1982 a394_cp90a1990 ... a
> 394_cp90a2010
                             a395_cp90a   ->   a395_cp90a1982 a395_cp90a1990 ... a
> 395_cp90a2010
                             a396_cp90a   ->   a396_cp90a1982 a396_cp90a1990 ... a
> 396_cp90a2010
                             a397_cp90a   ->   a397_cp90a1982 a397_cp90a1990 ... a
> 397_cp90a2010
                             a398_cp90a   ->   a398_cp90a1982 a398_cp90a1990 ... a
> 398_cp90a2010
                             a399_cp90a   ->   a399_cp90a1982 a399_cp90a1990 ... a
> 399_cp90a2010
                             a400_cp90a   ->   a400_cp90a1982 a400_cp90a1990 ... a
> 400_cp90a2010
                             a401_cp90a   ->   a401_cp90a1982 a401_cp90a1990 ... a
> 401_cp90a2010
                             a402_cp90a   ->   a402_cp90a1982 a402_cp90a1990 ... a
> 402_cp90a2010
                             a403_cp90a   ->   a403_cp90a1982 a403_cp90a1990 ... a
> 403_cp90a2010
                             a404_cp90a   ->   a404_cp90a1982 a404_cp90a1990 ... a
> 404_cp90a2010
                             a405_cp90a   ->   a405_cp90a1982 a405_cp90a1990 ... a
> 405_cp90a2010
                             a406_cp90a   ->   a406_cp90a1982 a406_cp90a1990 ... a
> 406_cp90a2010
                             a407_cp90a   ->   a407_cp90a1982 a407_cp90a1990 ... a
> 407_cp90a2010
                             a408_cp90a   ->   a408_cp90a1982 a408_cp90a1990 ... a
> 408_cp90a2010
                             a409_cp90a   ->   a409_cp90a1982 a409_cp90a1990 ... a
> 409_cp90a2010
                             a410_cp90a   ->   a410_cp90a1982 a410_cp90a1990 ... a
> 410_cp90a2010
                             a411_cp90a   ->   a411_cp90a1982 a411_cp90a1990 ... a
> 411_cp90a2010
                             a412_cp90a   ->   a412_cp90a1982 a412_cp90a1990 ... a
> 412_cp90a2010
                             a413_cp90a   ->   a413_cp90a1982 a413_cp90a1990 ... a
> 413_cp90a2010
                             a414_cp90a   ->   a414_cp90a1982 a414_cp90a1990 ... a
> 414_cp90a2010
                             a415_cp90a   ->   a415_cp90a1982 a415_cp90a1990 ... a
> 415_cp90a2010
                             a416_cp90a   ->   a416_cp90a1982 a416_cp90a1990 ... a
> 416_cp90a2010
                             a417_cp90a   ->   a417_cp90a1982 a417_cp90a1990 ... a
> 417_cp90a2010
                             a418_cp90a   ->   a418_cp90a1982 a418_cp90a1990 ... a
> 418_cp90a2010
                             a419_cp90a   ->   a419_cp90a1982 a419_cp90a1990 ... a
> 419_cp90a2010
                             a420_cp90a   ->   a420_cp90a1982 a420_cp90a1990 ... a
> 420_cp90a2010
                             a421_cp90a   ->   a421_cp90a1982 a421_cp90a1990 ... a
> 421_cp90a2010
                             a422_cp90a   ->   a422_cp90a1982 a422_cp90a1990 ... a
> 422_cp90a2010
                             a423_cp90a   ->   a423_cp90a1982 a423_cp90a1990 ... a
> 423_cp90a2010
                             a424_cp90a   ->   a424_cp90a1982 a424_cp90a1990 ... a
> 424_cp90a2010
                             a425_cp90a   ->   a425_cp90a1982 a425_cp90a1990 ... a
> 425_cp90a2010
                             a426_cp90a   ->   a426_cp90a1982 a426_cp90a1990 ... a
> 426_cp90a2010
                             a427_cp90a   ->   a427_cp90a1982 a427_cp90a1990 ... a
> 427_cp90a2010
                             a428_cp90a   ->   a428_cp90a1982 a428_cp90a1990 ... a
> 428_cp90a2010
                             a432_cp90a   ->   a432_cp90a1982 a432_cp90a1990 ... a
> 432_cp90a2010
                             a433_cp90a   ->   a433_cp90a1982 a433_cp90a1990 ... a
> 433_cp90a2010
                             a435_cp90a   ->   a435_cp90a1982 a435_cp90a1990 ... a
> 435_cp90a2010
                             a436_cp90a   ->   a436_cp90a1982 a436_cp90a1990 ... a
> 436_cp90a2010
                             a438_cp90a   ->   a438_cp90a1982 a438_cp90a1990 ... a
> 438_cp90a2010
                             a439_cp90a   ->   a439_cp90a1982 a439_cp90a1990 ... a
> 439_cp90a2010
                             a440_cp90a   ->   a440_cp90a1982 a440_cp90a1990 ... a
> 440_cp90a2010
                             a441_cp90a   ->   a441_cp90a1982 a441_cp90a1990 ... a
> 441_cp90a2010
                             a442_cp90a   ->   a442_cp90a1982 a442_cp90a1990 ... a
> 442_cp90a2010
                             a443_cp90a   ->   a443_cp90a1982 a443_cp90a1990 ... a
> 443_cp90a2010
                             a444_cp90a   ->   a444_cp90a1982 a444_cp90a1990 ... a
> 444_cp90a2010
                             a445_cp90a   ->   a445_cp90a1982 a445_cp90a1990 ... a
> 445_cp90a2010
                             a447_cp90a   ->   a447_cp90a1982 a447_cp90a1990 ... a
> 447_cp90a2010
                             a448_cp90a   ->   a448_cp90a1982 a448_cp90a1990 ... a
> 448_cp90a2010
                             a450_cp90a   ->   a450_cp90a1982 a450_cp90a1990 ... a
> 450_cp90a2010
                             a452_cp90a   ->   a452_cp90a1982 a452_cp90a1990 ... a
> 452_cp90a2010
                       c_totalPop_cp90a   ->   c_totalPop_cp90a1982 c_totalPop_cp9
> 0a1990 ... c_totalPop_cp90a2010
                            c_emp_cp90a   ->   c_emp_cp90a1982 c_emp_cp90a1990 ...
>  c_emp_cp90a2010
                         c_emp_ag_cp90a   ->   c_emp_ag_cp90a1982 c_emp_ag_cp90a19
> 90 ... c_emp_ag_cp90a2010
                        c_emp_min_cp90a   ->   c_emp_min_cp90a1982 c_emp_min_cp90a
> 1990 ... c_emp_min_cp90a2010
                        c_emp_man_cp90a   ->   c_emp_man_cp90a1982 c_emp_man_cp90a
> 1990 ... c_emp_man_cp90a2010
                   c_emp_man_trad_cp90a   ->   c_emp_man_trad_cp90a1982 c_emp_man_
> trad_cp90a1990 ... c_emp_man_trad_cp90a2010
                   c_emp_man_chem_cp90a   ->   c_emp_man_chem_cp90a1982 c_emp_man_
> chem_cp90a1990 ... c_emp_man_chem_cp90a2010
                    c_emp_man_hvy_cp90a   ->   c_emp_man_hvy_cp90a1982 c_emp_man_h
> vy_cp90a1990 ... c_emp_man_hvy_cp90a2010
                 c_emp_man_hitech_cp90a   ->   c_emp_man_hitech_cp90a1982 c_emp_ma
> n_hitech_cp90a1990 ... c_emp_man_hitech_cp90a2010
                       c_emp_util_cp90a   ->   c_emp_util_cp90a1982 c_emp_util_cp9
> 0a1990 ... c_emp_util_cp90a2010
                       c_emp_cons_cp90a   ->   c_emp_cons_cp90a1982 c_emp_cons_cp9
> 0a1990 ... c_emp_cons_cp90a2010
                       c_emp_soft_cp90a   ->   c_emp_soft_cp90a1982 c_emp_soft_cp9
> 0a1990 ... c_emp_soft_cp90a2010
                       c_emp_whsl_cp90a   ->   c_emp_whsl_cp90a1982 c_emp_whsl_cp9
> 0a1990 ... c_emp_whsl_cp90a2010
                       c_emp_fina_cp90a   ->   c_emp_fina_cp90a1982 c_emp_fina_cp9
> 0a1990 ... c_emp_fina_cp90a2010
                        c_emp_res_cp90a   ->   c_emp_res_cp90a1982 c_emp_res_cp90a
> 1990 ... c_emp_res_cp90a2010
                        c_emp_cul_cp90a   ->   c_emp_cul_cp90a1982 c_emp_cul_cp90a
> 1990 ... c_emp_cul_cp90a2010
                        c_emp_pub_cp90a   ->   c_emp_pub_cp90a1982 c_emp_pub_cp90a
> 1990 ... c_emp_pub_cp90a2010
                       c_emp_tran_cp90a   ->   c_emp_tran_cp90a1982 c_emp_tran_cp9
> 0a1990 ... c_emp_tran_cp90a2010
                        c_rur_Mig_cp90a   ->   c_rur_Mig_cp90a1982 c_rur_Mig_cp90a
> 1990 ... c_rur_Mig_cp90a2010
                        c_urb_Mig_cp90a   ->   c_urb_Mig_cp90a1982 c_urb_Mig_cp90a
> 1990 ... c_urb_Mig_cp90a2010
                c_rur_mig_19to55__cp90a   ->   c_rur_mig_19to55__cp90a1982 c_rur_m
> ig_19to55__cp90a1990 ... c_rur_mig_19to55__cp90a2010
               c_rur_mig_19to55_h_cp90a   ->   c_rur_mig_19to55_h_cp90a1982 c_rur_
> mig_19to55_h_cp90a1990 ... c_rur_mig_19to55_h_cp90a2010
                c_urb_mig_19to55__cp90a   ->   c_urb_mig_19to55__cp90a1982 c_urb_m
> ig_19to55__cp90a1990 ... c_urb_mig_19to55__cp90a2010
               c_urb_mig_19to55_h_cp90a   ->   c_urb_mig_19to55_h_cp90a1982 c_urb_
> mig_19to55_h_cp90a1990 ... c_urb_mig_19to55_h_cp90a2010
                       c_f_19to55_cp90a   ->   c_f_19to55_cp90a1982 c_f_19to55_cp9
> 0a1990 ... c_f_19to55_cp90a2010
                      c_f_Under19_cp90a   ->   c_f_Under19_cp90a1982 c_f_Under19_c
> p90a1990 ... c_f_Under19_cp90a2010
                       c_f_Over55_cp90a   ->   c_f_Over55_cp90a1982 c_f_Over55_cp9
> 0a1990 ... c_f_Over55_cp90a2010
                     c_f_19to55_h_cp90a   ->   c_f_19to55_h_cp90a1982 c_f_19to55_h
> _cp90a1990 ... c_f_19to55_h_cp90a2010
                    c_f_19to55_w__cp90a   ->   c_f_19to55_w__cp90a1982 c_f_19to55_
> w__cp90a1990 ... c_f_19to55_w__cp90a2010
                   c_f_19to55_w_h_cp90a   ->   c_f_19to55_w_h_cp90a1982 c_f_19to55
> _w_h_cp90a1990 ... c_f_19to55_w_h_cp90a2010
                   c_f_19to55_w_c_cp90a   ->   c_f_19to55_w_c_cp90a1982 c_f_19to55
> _w_c_cp90a1990 ... c_f_19to55_w_c_cp90a2010
                       c_m_19to55_cp90a   ->   c_m_19to55_cp90a1982 c_m_19to55_cp9
> 0a1990 ... c_m_19to55_cp90a2010
                      c_m_Under19_cp90a   ->   c_m_Under19_cp90a1982 c_m_Under19_c
> p90a1990 ... c_m_Under19_cp90a2010
                       c_m_Over55_cp90a   ->   c_m_Over55_cp90a1982 c_m_Over55_cp9
> 0a1990 ... c_m_Over55_cp90a2010
                     c_m_19to55_h_cp90a   ->   c_m_19to55_h_cp90a1982 c_m_19to55_h
> _cp90a1990 ... c_m_19to55_h_cp90a2010
                    c_m_19to55_w__cp90a   ->   c_m_19to55_w__cp90a1982 c_m_19to55_
> w__cp90a1990 ... c_m_19to55_w__cp90a2010
                   c_m_19to55_w_h_cp90a   ->   c_m_19to55_w_h_cp90a1982 c_m_19to55
> _w_h_cp90a1990 ... c_m_19to55_w_h_cp90a2010
                   c_m_19to55_w_c_cp90a   ->   c_m_19to55_w_c_cp90a1982 c_m_19to55
> _w_c_cp90a1990 ... c_m_19to55_w_c_cp90a2010
                      c_rur_mig_A_cp90a   ->   c_rur_mig_A_cp90a1982 c_rur_mig_A_c
> p90a1990 ... c_rur_mig_A_cp90a2010
                      c_urb_mig_A_cp90a   ->   c_urb_mig_A_cp90a1982 c_urb_mig_A_c
> p90a1990 ... c_urb_mig_A_cp90a2010
               c_rur_mig_19to55_A_cp90a   ->   c_rur_mig_19to55_A_cp90a1982 c_rur_
> mig_19to55_A_cp90a1990 ... c_rur_mig_19to55_A_cp90a2010
             c_rur_mig_19to55_h_A_cp90a   ->   c_rur_mig_19to55_h_A_cp90a1982 c_ru
> r_mig_19to55_h_A_cp90a1990 ... c_rur_mig_19to55_h_A_cp90a2010
               c_urb_mig_19to55_A_cp90a   ->   c_urb_mig_19to55_A_cp90a1982 c_urb_
> mig_19to55_A_cp90a1990 ... c_urb_mig_19to55_A_cp90a2010
             c_urb_mig_19to55_h_A_cp90a   ->   c_urb_mig_19to55_h_A_cp90a1982 c_ur
> b_mig_19to55_h_A_cp90a1990 ... c_urb_mig_19to55_h_A_cp90a2010
                        c_rur_ob__cp90a   ->   c_rur_ob__cp90a1982 c_rur_ob__cp90a
> 1990 ... c_rur_ob__cp90a2010
                        c_urb_ob__cp90a   ->   c_urb_ob__cp90a1982 c_urb_ob__cp90a
> 1990 ... c_urb_ob__cp90a2010
                 c_rur_ob_19to55__cp90a   ->   c_rur_ob_19to55__cp90a1982 c_rur_ob
> _19to55__cp90a1990 ... c_rur_ob_19to55__cp90a2010
                c_rur_ob_19to55_h_cp90a   ->   c_rur_ob_19to55_h_cp90a1982 c_rur_o
> b_19to55_h_cp90a1990 ... c_rur_ob_19to55_h_cp90a2010
                 c_urb_ob_19to55__cp90a   ->   c_urb_ob_19to55__cp90a1982 c_urb_ob
> _19to55__cp90a1990 ... c_urb_ob_19to55__cp90a2010
                c_urb_ob_19to55_h_cp90a   ->   c_urb_ob_19to55_h_cp90a1982 c_urb_o
> b_19to55_h_cp90a1990 ... c_urb_ob_19to55_h_cp90a2010
                      c_rur_ob_A1_cp90a   ->   c_rur_ob_A1_cp90a1982 c_rur_ob_A1_c
> p90a1990 ... c_rur_ob_A1_cp90a2010
                      c_urb_ob_A1_cp90a   ->   c_urb_ob_A1_cp90a1982 c_urb_ob_A1_c
> p90a1990 ... c_urb_ob_A1_cp90a2010
               c_rur_ob_19to55_A1_cp90a   ->   c_rur_ob_19to55_A1_cp90a1982 c_rur_
> ob_19to55_A1_cp90a1990 ... c_rur_ob_19to55_A1_cp90a2010
             c_rur_ob_19to55_h_A1_cp90a   ->   c_rur_ob_19to55_h_A1_cp90a1982 c_ru
> r_ob_19to55_h_A1_cp90a1990 ... c_rur_ob_19to55_h_A1_cp90a2010
               c_urb_ob_19to55_A1_cp90a   ->   c_urb_ob_19to55_A1_cp90a1982 c_urb_
> ob_19to55_A1_cp90a1990 ... c_urb_ob_19to55_A1_cp90a2010
             c_urb_ob_19to55_h_A1_cp90a   ->   c_urb_ob_19to55_h_A1_cp90a1982 c_ur
> b_ob_19to55_h_A1_cp90a1990 ... c_urb_ob_19to55_h_A1_cp90a2010
                      c_rur_ob_A2_cp90a   ->   c_rur_ob_A2_cp90a1982 c_rur_ob_A2_c
> p90a1990 ... c_rur_ob_A2_cp90a2010
                      c_urb_ob_A2_cp90a   ->   c_urb_ob_A2_cp90a1982 c_urb_ob_A2_c
> p90a1990 ... c_urb_ob_A2_cp90a2010
               c_rur_ob_19to55_A2_cp90a   ->   c_rur_ob_19to55_A2_cp90a1982 c_rur_
> ob_19to55_A2_cp90a1990 ... c_rur_ob_19to55_A2_cp90a2010
             c_rur_ob_19to55_h_A2_cp90a   ->   c_rur_ob_19to55_h_A2_cp90a1982 c_ru
> r_ob_19to55_h_A2_cp90a1990 ... c_rur_ob_19to55_h_A2_cp90a2010
               c_urb_ob_19to55_A2_cp90a   ->   c_urb_ob_19to55_A2_cp90a1982 c_urb_
> ob_19to55_A2_cp90a1990 ... c_urb_ob_19to55_A2_cp90a2010
             c_urb_ob_19to55_h_A2_cp90a   ->   c_urb_ob_19to55_h_A2_cp90a1982 c_ur
> b_ob_19to55_h_A2_cp90a1990 ... c_urb_ob_19to55_h_A2_cp90a2010
                        gdp_predc_cp90a   ->   gdp_predc_cp90a1982 gdp_predc_cp90a
> 1990 ... gdp_predc_cp90a2010
                  gdp_sect2_predc_cp90a   ->   gdp_sect2_predc_cp90a1982 gdp_sect2
> _predc_cp90a1990 ... gdp_sect2_predc_cp90a2010
                        gdp_predf_cp90a   ->   gdp_predf_cp90a1982 gdp_predf_cp90a
> 1990 ... gdp_predf_cp90a2010
                  gdp_sect2_predf_cp90a   ->   gdp_sect2_predf_cp90a1982 gdp_sect2
> _predf_cp90a1990 ... gdp_sect2_predf_cp90a2010
-----------------------------------------------------------------------------

. 
. foreach X of varlist *_cp90a* {
  2.         qui: sum `X'
  3.          if r(N)==0 {
  4.          drop `X'
  5.         }
  6. }

. sort city05

. save cp90a.dta, replace
(note: file cp90a.dta not found)
file cp90a.dta saved

. 
. 
. ****** 2. 1990 City Propers based on adding aggregates to cpt **********
. 
. *Census Data
. use ..\..\data\tabular_data_BJ\generated\cp90.dta

. gen city05 = city_code

. replace city05 = 421000 if city05==420400
(1 real change made)

. #delimit ;
delimiter now ;
. keep nmcenmq city05 year 
> a101-a452;

. #delimit cr
delimiter now cr
. sort city05 year

. save temp90.dta, replace
(note: file temp90.dta not found)
file temp90.dta saved

. 
. use ..\..\data\tabular_data_BJ\generated\cpt.dta

. #delimit ;
delimiter now ;
. keep city05 city_name year 
> gdp gdp_sector1 gdp_sector2 gdp_sector3 tot_pop 
> pop gdp_michigan gdp_sector2_mi gdp_sector3_mi givo area_paved_roads 
> avgsalary avgsalary_michigan fdi_py givo_py
> totemp gdp_py gdp_sect2 gdp_sect3 total_pop kmpr apr givo_soe givo_colt area fix
> invest fdi
> asset_*;

. #delimit cr
delimiter now cr
. 
. sort city05 year

. merge city05 year using temp90.dta
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab _merge if year==1990

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |          1        0.53        0.53
          2 |         17        8.99        9.52
          3 |        171       90.48      100.00
------------+-----------------------------------
      Total |        189      100.00

. ** These are outside of the study area or county cities that are captured in the
>  aggregated data
. ** _merge=1 is Hengshui which will show up later in the cp90a variables
. drop if _merge==2
(17 observations deleted)

. drop _merge

. 
. *** Rename all variables except those not in disag data, for which we don't have
>  remainders
. foreach X of varlist gdp-tot_pop pop-gdp_michigan a101-a452 asset_* {
  2.   rename `X' a_`X'
  3. }

. gen a_gdp_predf = gdp_py
(1,155 missing values generated)

. gen a_gdp_predc = gdp_py
(1,155 missing values generated)

. gen a_gdp_sect2_predf = gdp_sect2
(1,155 missing values generated)

. gen a_gdp_sect2_predc = gdp_sect2
(1,155 missing values generated)

. save cpt.dta, replace
(note: file cpt.dta not found)
file cpt.dta saved

. 
. sort city05 year

. merge city05 year using ..\..\data\tabular_data_BJ\generated\agg_cp90remain.dta
(note: you are using old merge syntax; see [D] merge for new syntax)
(note: variable city05 was float, now double to accommodate using data's values)

. *** _merge=1 are cases where city propers are exactly the right unit
. *** _merge=2 cases are only in 1982 or residual portions of promoted cities
. *** _merge=3 are cases in which there are urban districts but the cp geography i
> s different from the cp
. tab year _merge

           |              _merge
      year |         1          2          3 |     Total
-----------+---------------------------------+----------
      1982 |        70        189         23 |       282 
      1990 |       161          0         11 |       172 
      1995 |       165          0         32 |       197 
      2000 |       193          0         54 |       247 
      2005 |       199          0         69 |       268 
      2008 |       198          0         70 |       268 
      2010 |       197          0         71 |       268 
-----------+---------------------------------+----------
     Total |     1,183        189        330 |     1,702 


. #delimit ;
delimiter now ;
. keep year city05
> a434-a193 gdp gdp_py gdp_sect2 gdp_sect3
> gdp_sector1 gdp_sector2 gdp_sector3 tot_pop 
> area fixinvest gdp_predf gdp_predc gdp_sect2_predf gdp_sect2_predc
> pop gdp_michigan gdp_sector2_mi gdp_sector3_mi area_paved_roads 
> totemp total_pop kmpr apr givo givo_soe givo_colt fdi
> avgsalary avgsalary_michigan fdi_py givo_py asset_*
> a101-a452
> a_gdp a_gdp_sector1 a_gdp_sector2 a_gdp_sector3 a_tot_pop 
> a_pop a_gdp_michigan
> a_gdp_predf a_gdp_predc a_gdp_sect2_predf a_gdp_sect2_predc
> a_a101-a_a452
> a_asset_* _merge;

. drop a_asset_g_qz aN* a271_274 a272_275;

. *** For variables with rural information, piece together city proper + remainder
> ;
. foreach X of varlist gdp gdp_sector1 gdp_sector2 gdp_sector3 tot_pop 
> pop gdp_michigan gdp_predf gdp_predc gdp_sect2_predf gdp_sect2_predc
> a1* a2* a3* a4* asset_*{;
  2. replace a_`X' = `X'+a_`X' if _merge==3;
  3. rename a_`X' `X'_cp90;
  4. drop `X';
  5. };
(36 real changes made, 12 to missing)
(24 real changes made, 12 to missing)
(29 real changes made, 13 to missing)
(29 real changes made, 20 to missing)
(54 real changes made, 6 to missing)
(264 real changes made, 122 to missing)
(264 real changes made, 141 to missing)
(40 real changes made, 29 to missing)
(40 real changes made, 29 to missing)
(40 real changes made, 29 to missing)
(40 real changes made, 29 to missing)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(6 real changes made)
(6 real changes made)
(6 real changes made)
(6 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(10 real changes made)
(11 real changes made)
(10 real changes made)
(4 real changes made)
(10 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(9 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(8 real changes made)
(8 real changes made)
(7 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(9 real changes made)
(9 real changes made)
(8 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(11 real changes made)
(7 real changes made)
variable a_asset_n_qz was long now double
(204 real changes made, 171 to missing)

. #delimit cr
delimiter now cr
. 
. foreach X of varlist totemp-fdi_py gdp_sector2_mi-fdi {
  2. replace `X' = . if _merge==3
  3. rename `X' `X'_cp90
  4. }
(40 real changes made, 40 to missing)
(40 real changes made, 40 to missing)
(40 real changes made, 40 to missing)
(40 real changes made, 40 to missing)
(40 real changes made, 40 to missing)
(29 real changes made, 29 to missing)
(11 real changes made, 11 to missing)
(40 real changes made, 40 to missing)
(40 real changes made, 40 to missing)
(11 real changes made, 11 to missing)
(11 real changes made, 11 to missing)
(11 real changes made, 11 to missing)
(41 real changes made, 41 to missing)
(39 real changes made, 39 to missing)
(264 real changes made, 264 to missing)
(264 real changes made, 264 to missing)
(264 real changes made, 264 to missing)
(264 real changes made, 264 to missing)
(264 real changes made, 264 to missing)
(259 real changes made, 259 to missing)

. 
. drop _merge

. drop if year==1982
(282 observations deleted)

. 
. reshape wide *_cp90, i(city05) j(year)
(note: j = 1990 1995 2000 2005 2008 2010)

Data                               long   ->   wide
-----------------------------------------------------------------------------
Number of obs.                     1420   ->     268
Number of variables                 295   ->    1759
j variable (6 values)              year   ->   (dropped)
xij variables:
                               gdp_cp90   ->   gdp_cp901990 gdp_cp901995 ... gdp_c
> p902010
                       gdp_sector1_cp90   ->   gdp_sector1_cp901990 gdp_sector1_cp
> 901995 ... gdp_sector1_cp902010
                       gdp_sector2_cp90   ->   gdp_sector2_cp901990 gdp_sector2_cp
> 901995 ... gdp_sector2_cp902010
                       gdp_sector3_cp90   ->   gdp_sector3_cp901990 gdp_sector3_cp
> 901995 ... gdp_sector3_cp902010
                           tot_pop_cp90   ->   tot_pop_cp901990 tot_pop_cp901995 .
> .. tot_pop_cp902010
                            totemp_cp90   ->   totemp_cp901990 totemp_cp901995 ...
>  totemp_cp902010
                            gdp_py_cp90   ->   gdp_py_cp901990 gdp_py_cp901995 ...
>  gdp_py_cp902010
                         gdp_sect2_cp90   ->   gdp_sect2_cp901990 gdp_sect2_cp9019
> 95 ... gdp_sect2_cp902010
                         gdp_sect3_cp90   ->   gdp_sect3_cp901990 gdp_sect3_cp9019
> 95 ... gdp_sect3_cp902010
                         total_pop_cp90   ->   total_pop_cp901990 total_pop_cp9019
> 95 ... total_pop_cp902010
                              kmpr_cp90   ->   kmpr_cp901990 kmpr_cp901995 ... kmp
> r_cp902010
                               apr_cp90   ->   apr_cp901990 apr_cp901995 ... apr_c
> p902010
                         avgsalary_cp90   ->   avgsalary_cp901990 avgsalary_cp9019
> 95 ... avgsalary_cp902010
                           givo_py_cp90   ->   givo_py_cp901990 givo_py_cp901995 .
> .. givo_py_cp902010
                          givo_soe_cp90   ->   givo_soe_cp901990 givo_soe_cp901995
>  ... givo_soe_cp902010
                         givo_colt_cp90   ->   givo_colt_cp901990 givo_colt_cp9019
> 95 ... givo_colt_cp902010
                              area_cp90   ->   area_cp901990 area_cp901995 ... are
> a_cp902010
                         fixinvest_cp90   ->   fixinvest_cp901990 fixinvest_cp9019
> 95 ... fixinvest_cp902010
                            fdi_py_cp90   ->   fdi_py_cp901990 fdi_py_cp901995 ...
>  fdi_py_cp902010
                               pop_cp90   ->   pop_cp901990 pop_cp901995 ... pop_c
> p902010
                      gdp_michigan_cp90   ->   gdp_michigan_cp901990 gdp_michigan_
> cp901995 ... gdp_michigan_cp902010
                    gdp_sector2_mi_cp90   ->   gdp_sector2_mi_cp901990 gdp_sector2
> _mi_cp901995 ... gdp_sector2_mi_cp902010
                    gdp_sector3_mi_cp90   ->   gdp_sector3_mi_cp901990 gdp_sector3
> _mi_cp901995 ... gdp_sector3_mi_cp902010
                              givo_cp90   ->   givo_cp901990 givo_cp901995 ... giv
> o_cp902010
                avgsalary_michigan_cp90   ->   avgsalary_michigan_cp901990 avgsala
> ry_michigan_cp901995 ... avgsalary_michigan_cp902010
                  area_paved_roads_cp90   ->   area_paved_roads_cp901990 area_pave
> d_roads_cp901995 ... area_paved_roads_cp902010
                               fdi_cp90   ->   fdi_cp901990 fdi_cp901995 ... fdi_c
> p902010
                        asset_n_qz_cp90   ->   asset_n_qz_cp901990 asset_n_qz_cp90
> 1995 ... asset_n_qz_cp902010
                              a101_cp90   ->   a101_cp901990 a101_cp901995 ... a10
> 1_cp902010
                              a102_cp90   ->   a102_cp901990 a102_cp901995 ... a10
> 2_cp902010
                              a103_cp90   ->   a103_cp901990 a103_cp901995 ... a10
> 3_cp902010
                              a104_cp90   ->   a104_cp901990 a104_cp901995 ... a10
> 4_cp902010
                              a105_cp90   ->   a105_cp901990 a105_cp901995 ... a10
> 5_cp902010
                              a106_cp90   ->   a106_cp901990 a106_cp901995 ... a10
> 6_cp902010
                              a107_cp90   ->   a107_cp901990 a107_cp901995 ... a10
> 7_cp902010
                              a108_cp90   ->   a108_cp901990 a108_cp901995 ... a10
> 8_cp902010
                              a109_cp90   ->   a109_cp901990 a109_cp901995 ... a10
> 9_cp902010
                              a110_cp90   ->   a110_cp901990 a110_cp901995 ... a11
> 0_cp902010
                              a111_cp90   ->   a111_cp901990 a111_cp901995 ... a11
> 1_cp902010
                              a112_cp90   ->   a112_cp901990 a112_cp901995 ... a11
> 2_cp902010
                              a113_cp90   ->   a113_cp901990 a113_cp901995 ... a11
> 3_cp902010
                              a114_cp90   ->   a114_cp901990 a114_cp901995 ... a11
> 4_cp902010
                              a115_cp90   ->   a115_cp901990 a115_cp901995 ... a11
> 5_cp902010
                              a116_cp90   ->   a116_cp901990 a116_cp901995 ... a11
> 6_cp902010
                              a117_cp90   ->   a117_cp901990 a117_cp901995 ... a11
> 7_cp902010
                              a118_cp90   ->   a118_cp901990 a118_cp901995 ... a11
> 8_cp902010
                              a119_cp90   ->   a119_cp901990 a119_cp901995 ... a11
> 9_cp902010
                              a120_cp90   ->   a120_cp901990 a120_cp901995 ... a12
> 0_cp902010
                              a121_cp90   ->   a121_cp901990 a121_cp901995 ... a12
> 1_cp902010
                              a122_cp90   ->   a122_cp901990 a122_cp901995 ... a12
> 2_cp902010
                              a123_cp90   ->   a123_cp901990 a123_cp901995 ... a12
> 3_cp902010
                              a124_cp90   ->   a124_cp901990 a124_cp901995 ... a12
> 4_cp902010
                              a125_cp90   ->   a125_cp901990 a125_cp901995 ... a12
> 5_cp902010
                              a126_cp90   ->   a126_cp901990 a126_cp901995 ... a12
> 6_cp902010
                              a127_cp90   ->   a127_cp901990 a127_cp901995 ... a12
> 7_cp902010
                              a128_cp90   ->   a128_cp901990 a128_cp901995 ... a12
> 8_cp902010
                              a129_cp90   ->   a129_cp901990 a129_cp901995 ... a12
> 9_cp902010
                              a130_cp90   ->   a130_cp901990 a130_cp901995 ... a13
> 0_cp902010
                              a131_cp90   ->   a131_cp901990 a131_cp901995 ... a13
> 1_cp902010
                              a132_cp90   ->   a132_cp901990 a132_cp901995 ... a13
> 2_cp902010
                              a133_cp90   ->   a133_cp901990 a133_cp901995 ... a13
> 3_cp902010
                              a134_cp90   ->   a134_cp901990 a134_cp901995 ... a13
> 4_cp902010
                              a135_cp90   ->   a135_cp901990 a135_cp901995 ... a13
> 5_cp902010
                              a136_cp90   ->   a136_cp901990 a136_cp901995 ... a13
> 6_cp902010
                              a137_cp90   ->   a137_cp901990 a137_cp901995 ... a13
> 7_cp902010
                              a138_cp90   ->   a138_cp901990 a138_cp901995 ... a13
> 8_cp902010
                              a139_cp90   ->   a139_cp901990 a139_cp901995 ... a13
> 9_cp902010
                              a140_cp90   ->   a140_cp901990 a140_cp901995 ... a14
> 0_cp902010
                              a141_cp90   ->   a141_cp901990 a141_cp901995 ... a14
> 1_cp902010
                              a142_cp90   ->   a142_cp901990 a142_cp901995 ... a14
> 2_cp902010
                              a143_cp90   ->   a143_cp901990 a143_cp901995 ... a14
> 3_cp902010
                              a144_cp90   ->   a144_cp901990 a144_cp901995 ... a14
> 4_cp902010
                              a145_cp90   ->   a145_cp901990 a145_cp901995 ... a14
> 5_cp902010
                              a146_cp90   ->   a146_cp901990 a146_cp901995 ... a14
> 6_cp902010
                              a181_cp90   ->   a181_cp901990 a181_cp901995 ... a18
> 1_cp902010
                              a182_cp90   ->   a182_cp901990 a182_cp901995 ... a18
> 2_cp902010
                              a183_cp90   ->   a183_cp901990 a183_cp901995 ... a18
> 3_cp902010
                              a184_cp90   ->   a184_cp901990 a184_cp901995 ... a18
> 4_cp902010
                              a185_cp90   ->   a185_cp901990 a185_cp901995 ... a18
> 5_cp902010
                              a186_cp90   ->   a186_cp901990 a186_cp901995 ... a18
> 6_cp902010
                              a187_cp90   ->   a187_cp901990 a187_cp901995 ... a18
> 7_cp902010
                              a188_cp90   ->   a188_cp901990 a188_cp901995 ... a18
> 8_cp902010
                              a189_cp90   ->   a189_cp901990 a189_cp901995 ... a18
> 9_cp902010
                              a190_cp90   ->   a190_cp901990 a190_cp901995 ... a19
> 0_cp902010
                              a191_cp90   ->   a191_cp901990 a191_cp901995 ... a19
> 1_cp902010
                              a192_cp90   ->   a192_cp901990 a192_cp901995 ... a19
> 2_cp902010
                              a193_cp90   ->   a193_cp901990 a193_cp901995 ... a19
> 3_cp902010
                              a194_cp90   ->   a194_cp901990 a194_cp901995 ... a19
> 4_cp902010
                              a195_cp90   ->   a195_cp901990 a195_cp901995 ... a19
> 5_cp902010
                              a196_cp90   ->   a196_cp901990 a196_cp901995 ... a19
> 6_cp902010
                              a197_cp90   ->   a197_cp901990 a197_cp901995 ... a19
> 7_cp902010
                              a198_cp90   ->   a198_cp901990 a198_cp901995 ... a19
> 8_cp902010
                              a199_cp90   ->   a199_cp901990 a199_cp901995 ... a19
> 9_cp902010
                              a200_cp90   ->   a200_cp901990 a200_cp901995 ... a20
> 0_cp902010
                              a201_cp90   ->   a201_cp901990 a201_cp901995 ... a20
> 1_cp902010
                              a202_cp90   ->   a202_cp901990 a202_cp901995 ... a20
> 2_cp902010
                              a203_cp90   ->   a203_cp901990 a203_cp901995 ... a20
> 3_cp902010
                              a204_cp90   ->   a204_cp901990 a204_cp901995 ... a20
> 4_cp902010
                              a205_cp90   ->   a205_cp901990 a205_cp901995 ... a20
> 5_cp902010
                              a206_cp90   ->   a206_cp901990 a206_cp901995 ... a20
> 6_cp902010
                              a207_cp90   ->   a207_cp901990 a207_cp901995 ... a20
> 7_cp902010
                              a208_cp90   ->   a208_cp901990 a208_cp901995 ... a20
> 8_cp902010
                              a209_cp90   ->   a209_cp901990 a209_cp901995 ... a20
> 9_cp902010
                              a210_cp90   ->   a210_cp901990 a210_cp901995 ... a21
> 0_cp902010
                              a211_cp90   ->   a211_cp901990 a211_cp901995 ... a21
> 1_cp902010
                              a212_cp90   ->   a212_cp901990 a212_cp901995 ... a21
> 2_cp902010
                              a213_cp90   ->   a213_cp901990 a213_cp901995 ... a21
> 3_cp902010
                              a214_cp90   ->   a214_cp901990 a214_cp901995 ... a21
> 4_cp902010
                              a215_cp90   ->   a215_cp901990 a215_cp901995 ... a21
> 5_cp902010
                              a216_cp90   ->   a216_cp901990 a216_cp901995 ... a21
> 6_cp902010
                              a217_cp90   ->   a217_cp901990 a217_cp901995 ... a21
> 7_cp902010
                              a218_cp90   ->   a218_cp901990 a218_cp901995 ... a21
> 8_cp902010
                              a219_cp90   ->   a219_cp901990 a219_cp901995 ... a21
> 9_cp902010
                              a220_cp90   ->   a220_cp901990 a220_cp901995 ... a22
> 0_cp902010
                              a221_cp90   ->   a221_cp901990 a221_cp901995 ... a22
> 1_cp902010
                              a222_cp90   ->   a222_cp901990 a222_cp901995 ... a22
> 2_cp902010
                              a223_cp90   ->   a223_cp901990 a223_cp901995 ... a22
> 3_cp902010
                              a224_cp90   ->   a224_cp901990 a224_cp901995 ... a22
> 4_cp902010
                              a225_cp90   ->   a225_cp901990 a225_cp901995 ... a22
> 5_cp902010
                              a226_cp90   ->   a226_cp901990 a226_cp901995 ... a22
> 6_cp902010
                              a227_cp90   ->   a227_cp901990 a227_cp901995 ... a22
> 7_cp902010
                              a228_cp90   ->   a228_cp901990 a228_cp901995 ... a22
> 8_cp902010
                              a229_cp90   ->   a229_cp901990 a229_cp901995 ... a22
> 9_cp902010
                              a230_cp90   ->   a230_cp901990 a230_cp901995 ... a23
> 0_cp902010
                              a231_cp90   ->   a231_cp901990 a231_cp901995 ... a23
> 1_cp902010
                              a232_cp90   ->   a232_cp901990 a232_cp901995 ... a23
> 2_cp902010
                              a233_cp90   ->   a233_cp901990 a233_cp901995 ... a23
> 3_cp902010
                              a234_cp90   ->   a234_cp901990 a234_cp901995 ... a23
> 4_cp902010
                              a235_cp90   ->   a235_cp901990 a235_cp901995 ... a23
> 5_cp902010
                              a236_cp90   ->   a236_cp901990 a236_cp901995 ... a23
> 6_cp902010
                              a237_cp90   ->   a237_cp901990 a237_cp901995 ... a23
> 7_cp902010
                              a238_cp90   ->   a238_cp901990 a238_cp901995 ... a23
> 8_cp902010
                              a239_cp90   ->   a239_cp901990 a239_cp901995 ... a23
> 9_cp902010
                              a240_cp90   ->   a240_cp901990 a240_cp901995 ... a24
> 0_cp902010
                              a241_cp90   ->   a241_cp901990 a241_cp901995 ... a24
> 1_cp902010
                              a242_cp90   ->   a242_cp901990 a242_cp901995 ... a24
> 2_cp902010
                              a243_cp90   ->   a243_cp901990 a243_cp901995 ... a24
> 3_cp902010
                              a244_cp90   ->   a244_cp901990 a244_cp901995 ... a24
> 4_cp902010
                              a245_cp90   ->   a245_cp901990 a245_cp901995 ... a24
> 5_cp902010
                              a246_cp90   ->   a246_cp901990 a246_cp901995 ... a24
> 6_cp902010
                              a261_cp90   ->   a261_cp901990 a261_cp901995 ... a26
> 1_cp902010
                              a262_cp90   ->   a262_cp901990 a262_cp901995 ... a26
> 2_cp902010
                              a263_cp90   ->   a263_cp901990 a263_cp901995 ... a26
> 3_cp902010
                              a264_cp90   ->   a264_cp901990 a264_cp901995 ... a26
> 4_cp902010
                              a265_cp90   ->   a265_cp901990 a265_cp901995 ... a26
> 5_cp902010
                              a266_cp90   ->   a266_cp901990 a266_cp901995 ... a26
> 6_cp902010
                              a267_cp90   ->   a267_cp901990 a267_cp901995 ... a26
> 7_cp902010
                              a268_cp90   ->   a268_cp901990 a268_cp901995 ... a26
> 8_cp902010
                              a269_cp90   ->   a269_cp901990 a269_cp901995 ... a26
> 9_cp902010
                              a270_cp90   ->   a270_cp901990 a270_cp901995 ... a27
> 0_cp902010
                              a271_cp90   ->   a271_cp901990 a271_cp901995 ... a27
> 1_cp902010
                              a272_cp90   ->   a272_cp901990 a272_cp901995 ... a27
> 2_cp902010
                              a273_cp90   ->   a273_cp901990 a273_cp901995 ... a27
> 3_cp902010
                              a274_cp90   ->   a274_cp901990 a274_cp901995 ... a27
> 4_cp902010
                              a275_cp90   ->   a275_cp901990 a275_cp901995 ... a27
> 5_cp902010
                              a276_cp90   ->   a276_cp901990 a276_cp901995 ... a27
> 6_cp902010
                              a277_cp90   ->   a277_cp901990 a277_cp901995 ... a27
> 7_cp902010
                              a278_cp90   ->   a278_cp901990 a278_cp901995 ... a27
> 8_cp902010
                              a279_cp90   ->   a279_cp901990 a279_cp901995 ... a27
> 9_cp902010
                              a280_cp90   ->   a280_cp901990 a280_cp901995 ... a28
> 0_cp902010
                              a281_cp90   ->   a281_cp901990 a281_cp901995 ... a28
> 1_cp902010
                              a282_cp90   ->   a282_cp901990 a282_cp901995 ... a28
> 2_cp902010
                              a283_cp90   ->   a283_cp901990 a283_cp901995 ... a28
> 3_cp902010
                              a284_cp90   ->   a284_cp901990 a284_cp901995 ... a28
> 4_cp902010
                              a291_cp90   ->   a291_cp901990 a291_cp901995 ... a29
> 1_cp902010
                              a292_cp90   ->   a292_cp901990 a292_cp901995 ... a29
> 2_cp902010
                              a293_cp90   ->   a293_cp901990 a293_cp901995 ... a29
> 3_cp902010
                              a294_cp90   ->   a294_cp901990 a294_cp901995 ... a29
> 4_cp902010
                              a295_cp90   ->   a295_cp901990 a295_cp901995 ... a29
> 5_cp902010
                              a296_cp90   ->   a296_cp901990 a296_cp901995 ... a29
> 6_cp902010
                              a301_cp90   ->   a301_cp901990 a301_cp901995 ... a30
> 1_cp902010
                              a302_cp90   ->   a302_cp901990 a302_cp901995 ... a30
> 2_cp902010
                              a303_cp90   ->   a303_cp901990 a303_cp901995 ... a30
> 3_cp902010
                              a304_cp90   ->   a304_cp901990 a304_cp901995 ... a30
> 4_cp902010
                              a305_cp90   ->   a305_cp901990 a305_cp901995 ... a30
> 5_cp902010
                              a306_cp90   ->   a306_cp901990 a306_cp901995 ... a30
> 6_cp902010
                              a307_cp90   ->   a307_cp901990 a307_cp901995 ... a30
> 7_cp902010
                              a308_cp90   ->   a308_cp901990 a308_cp901995 ... a30
> 8_cp902010
                              a309_cp90   ->   a309_cp901990 a309_cp901995 ... a30
> 9_cp902010
                              a310_cp90   ->   a310_cp901990 a310_cp901995 ... a31
> 0_cp902010
                              a311_cp90   ->   a311_cp901990 a311_cp901995 ... a31
> 1_cp902010
                              a312_cp90   ->   a312_cp901990 a312_cp901995 ... a31
> 2_cp902010
                              a313_cp90   ->   a313_cp901990 a313_cp901995 ... a31
> 3_cp902010
                              a314_cp90   ->   a314_cp901990 a314_cp901995 ... a31
> 4_cp902010
                              a315_cp90   ->   a315_cp901990 a315_cp901995 ... a31
> 5_cp902010
                              a321_cp90   ->   a321_cp901990 a321_cp901995 ... a32
> 1_cp902010
                              a322_cp90   ->   a322_cp901990 a322_cp901995 ... a32
> 2_cp902010
                              a323_cp90   ->   a323_cp901990 a323_cp901995 ... a32
> 3_cp902010
                              a324_cp90   ->   a324_cp901990 a324_cp901995 ... a32
> 4_cp902010
                              a325_cp90   ->   a325_cp901990 a325_cp901995 ... a32
> 5_cp902010
                              a326_cp90   ->   a326_cp901990 a326_cp901995 ... a32
> 6_cp902010
                              a327_cp90   ->   a327_cp901990 a327_cp901995 ... a32
> 7_cp902010
                              a328_cp90   ->   a328_cp901990 a328_cp901995 ... a32
> 8_cp902010
                              a329_cp90   ->   a329_cp901990 a329_cp901995 ... a32
> 9_cp902010
                              a330_cp90   ->   a330_cp901990 a330_cp901995 ... a33
> 0_cp902010
                              a331_cp90   ->   a331_cp901990 a331_cp901995 ... a33
> 1_cp902010
                              a332_cp90   ->   a332_cp901990 a332_cp901995 ... a33
> 2_cp902010
                              a341_cp90   ->   a341_cp901990 a341_cp901995 ... a34
> 1_cp902010
                              a342_cp90   ->   a342_cp901990 a342_cp901995 ... a34
> 2_cp902010
                              a343_cp90   ->   a343_cp901990 a343_cp901995 ... a34
> 3_cp902010
                              a344_cp90   ->   a344_cp901990 a344_cp901995 ... a34
> 4_cp902010
                              a345_cp90   ->   a345_cp901990 a345_cp901995 ... a34
> 5_cp902010
                              a346_cp90   ->   a346_cp901990 a346_cp901995 ... a34
> 6_cp902010
                              a347_cp90   ->   a347_cp901990 a347_cp901995 ... a34
> 7_cp902010
                              a348_cp90   ->   a348_cp901990 a348_cp901995 ... a34
> 8_cp902010
                              a349_cp90   ->   a349_cp901990 a349_cp901995 ... a34
> 9_cp902010
                              a350_cp90   ->   a350_cp901990 a350_cp901995 ... a35
> 0_cp902010
                              a351_cp90   ->   a351_cp901990 a351_cp901995 ... a35
> 1_cp902010
                              a352_cp90   ->   a352_cp901990 a352_cp901995 ... a35
> 2_cp902010
                              a361_cp90   ->   a361_cp901990 a361_cp901995 ... a36
> 1_cp902010
                              a362_cp90   ->   a362_cp901990 a362_cp901995 ... a36
> 2_cp902010
                              a363_cp90   ->   a363_cp901990 a363_cp901995 ... a36
> 3_cp902010
                              a364_cp90   ->   a364_cp901990 a364_cp901995 ... a36
> 4_cp902010
                              a365_cp90   ->   a365_cp901990 a365_cp901995 ... a36
> 5_cp902010
                              a366_cp90   ->   a366_cp901990 a366_cp901995 ... a36
> 6_cp902010
                              a367_cp90   ->   a367_cp901990 a367_cp901995 ... a36
> 7_cp902010
                              a368_cp90   ->   a368_cp901990 a368_cp901995 ... a36
> 8_cp902010
                              a369_cp90   ->   a369_cp901990 a369_cp901995 ... a36
> 9_cp902010
                              a370_cp90   ->   a370_cp901990 a370_cp901995 ... a37
> 0_cp902010
                              a381_cp90   ->   a381_cp901990 a381_cp901995 ... a38
> 1_cp902010
                              a382_cp90   ->   a382_cp901990 a382_cp901995 ... a38
> 2_cp902010
                              a383_cp90   ->   a383_cp901990 a383_cp901995 ... a38
> 3_cp902010
                              a384_cp90   ->   a384_cp901990 a384_cp901995 ... a38
> 4_cp902010
                              a385_cp90   ->   a385_cp901990 a385_cp901995 ... a38
> 5_cp902010
                              a386_cp90   ->   a386_cp901990 a386_cp901995 ... a38
> 6_cp902010
                              a387_cp90   ->   a387_cp901990 a387_cp901995 ... a38
> 7_cp902010
                              a388_cp90   ->   a388_cp901990 a388_cp901995 ... a38
> 8_cp902010
                              a389_cp90   ->   a389_cp901990 a389_cp901995 ... a38
> 9_cp902010
                              a390_cp90   ->   a390_cp901990 a390_cp901995 ... a39
> 0_cp902010
                              a391_cp90   ->   a391_cp901990 a391_cp901995 ... a39
> 1_cp902010
                              a392_cp90   ->   a392_cp901990 a392_cp901995 ... a39
> 2_cp902010
                              a393_cp90   ->   a393_cp901990 a393_cp901995 ... a39
> 3_cp902010
                              a394_cp90   ->   a394_cp901990 a394_cp901995 ... a39
> 4_cp902010
                              a395_cp90   ->   a395_cp901990 a395_cp901995 ... a39
> 5_cp902010
                              a396_cp90   ->   a396_cp901990 a396_cp901995 ... a39
> 6_cp902010
                              a397_cp90   ->   a397_cp901990 a397_cp901995 ... a39
> 7_cp902010
                              a398_cp90   ->   a398_cp901990 a398_cp901995 ... a39
> 8_cp902010
                              a399_cp90   ->   a399_cp901990 a399_cp901995 ... a39
> 9_cp902010
                              a400_cp90   ->   a400_cp901990 a400_cp901995 ... a40
> 0_cp902010
                              a401_cp90   ->   a401_cp901990 a401_cp901995 ... a40
> 1_cp902010
                              a402_cp90   ->   a402_cp901990 a402_cp901995 ... a40
> 2_cp902010
                              a403_cp90   ->   a403_cp901990 a403_cp901995 ... a40
> 3_cp902010
                              a404_cp90   ->   a404_cp901990 a404_cp901995 ... a40
> 4_cp902010
                              a405_cp90   ->   a405_cp901990 a405_cp901995 ... a40
> 5_cp902010
                              a406_cp90   ->   a406_cp901990 a406_cp901995 ... a40
> 6_cp902010
                              a407_cp90   ->   a407_cp901990 a407_cp901995 ... a40
> 7_cp902010
                              a408_cp90   ->   a408_cp901990 a408_cp901995 ... a40
> 8_cp902010
                              a409_cp90   ->   a409_cp901990 a409_cp901995 ... a40
> 9_cp902010
                              a410_cp90   ->   a410_cp901990 a410_cp901995 ... a41
> 0_cp902010
                              a411_cp90   ->   a411_cp901990 a411_cp901995 ... a41
> 1_cp902010
                              a412_cp90   ->   a412_cp901990 a412_cp901995 ... a41
> 2_cp902010
                              a413_cp90   ->   a413_cp901990 a413_cp901995 ... a41
> 3_cp902010
                              a414_cp90   ->   a414_cp901990 a414_cp901995 ... a41
> 4_cp902010
                              a415_cp90   ->   a415_cp901990 a415_cp901995 ... a41
> 5_cp902010
                              a416_cp90   ->   a416_cp901990 a416_cp901995 ... a41
> 6_cp902010
                              a417_cp90   ->   a417_cp901990 a417_cp901995 ... a41
> 7_cp902010
                              a418_cp90   ->   a418_cp901990 a418_cp901995 ... a41
> 8_cp902010
                              a419_cp90   ->   a419_cp901990 a419_cp901995 ... a41
> 9_cp902010
                              a420_cp90   ->   a420_cp901990 a420_cp901995 ... a42
> 0_cp902010
                              a421_cp90   ->   a421_cp901990 a421_cp901995 ... a42
> 1_cp902010
                              a422_cp90   ->   a422_cp901990 a422_cp901995 ... a42
> 2_cp902010
                              a423_cp90   ->   a423_cp901990 a423_cp901995 ... a42
> 3_cp902010
                              a424_cp90   ->   a424_cp901990 a424_cp901995 ... a42
> 4_cp902010
                              a425_cp90   ->   a425_cp901990 a425_cp901995 ... a42
> 5_cp902010
                              a426_cp90   ->   a426_cp901990 a426_cp901995 ... a42
> 6_cp902010
                              a427_cp90   ->   a427_cp901990 a427_cp901995 ... a42
> 7_cp902010
                              a428_cp90   ->   a428_cp901990 a428_cp901995 ... a42
> 8_cp902010
                              a431_cp90   ->   a431_cp901990 a431_cp901995 ... a43
> 1_cp902010
                              a432_cp90   ->   a432_cp901990 a432_cp901995 ... a43
> 2_cp902010
                              a433_cp90   ->   a433_cp901990 a433_cp901995 ... a43
> 3_cp902010
                              a434_cp90   ->   a434_cp901990 a434_cp901995 ... a43
> 4_cp902010
                              a435_cp90   ->   a435_cp901990 a435_cp901995 ... a43
> 5_cp902010
                              a436_cp90   ->   a436_cp901990 a436_cp901995 ... a43
> 6_cp902010
                              a437_cp90   ->   a437_cp901990 a437_cp901995 ... a43
> 7_cp902010
                              a438_cp90   ->   a438_cp901990 a438_cp901995 ... a43
> 8_cp902010
                              a439_cp90   ->   a439_cp901990 a439_cp901995 ... a43
> 9_cp902010
                              a440_cp90   ->   a440_cp901990 a440_cp901995 ... a44
> 0_cp902010
                              a441_cp90   ->   a441_cp901990 a441_cp901995 ... a44
> 1_cp902010
                              a442_cp90   ->   a442_cp901990 a442_cp901995 ... a44
> 2_cp902010
                              a443_cp90   ->   a443_cp901990 a443_cp901995 ... a44
> 3_cp902010
                              a444_cp90   ->   a444_cp901990 a444_cp901995 ... a44
> 4_cp902010
                              a445_cp90   ->   a445_cp901990 a445_cp901995 ... a44
> 5_cp902010
                              a446_cp90   ->   a446_cp901990 a446_cp901995 ... a44
> 6_cp902010
                              a447_cp90   ->   a447_cp901990 a447_cp901995 ... a44
> 7_cp902010
                              a448_cp90   ->   a448_cp901990 a448_cp901995 ... a44
> 8_cp902010
                              a449_cp90   ->   a449_cp901990 a449_cp901995 ... a44
> 9_cp902010
                              a450_cp90   ->   a450_cp901990 a450_cp901995 ... a45
> 0_cp902010
                              a451_cp90   ->   a451_cp901990 a451_cp901995 ... a45
> 1_cp902010
                              a452_cp90   ->   a452_cp901990 a452_cp901995 ... a45
> 2_cp902010
                         gdp_predf_cp90   ->   gdp_predf_cp901990 gdp_predf_cp9019
> 95 ... gdp_predf_cp902010
                         gdp_predc_cp90   ->   gdp_predc_cp901990 gdp_predc_cp9019
> 95 ... gdp_predc_cp902010
                   gdp_sect2_predf_cp90   ->   gdp_sect2_predf_cp901990 gdp_sect2_
> predf_cp901995 ... gdp_sect2_predf_cp902010
                   gdp_sect2_predc_cp90   ->   gdp_sect2_predc_cp901990 gdp_sect2_
> predc_cp901995 ... gdp_sect2_predc_cp902010
-----------------------------------------------------------------------------

. *** These are all covered in cp90a
. drop a*_cp902010

. foreach X of varlist gdp_cp901990-gdp_sect2_predc_cp902010 {
  2.         qui: sum `X'
  3.          if r(N)==0 {
  4.          drop `X'
  5.         }
  6. }

. 
. sort city05

. save cp90.dta, replace
(note: file cp90.dta not found)
file cp90.dta saved

. 
. 
. ******* 3. 2005 definition prefectures *****************
. 
. use ..\..\data\tabular_data_BJ\generated\agg_pref.dta

. #delimit ;
delimiter now ;
. keep city05 year gdp gdp_sector1 gdp_sector2 gdp_sector3 tot_pop pop gdp_michiga
> n
> c_totalPop c_emp c_f_* c_m_* c_rur_* c_urb_* c_emp_* a* aN* gdp_pred* gdp_sect2_
> pred*
> city_name;

. #delimit cr
delimiter now cr
. drop if city05==.
(0 observations deleted)

. gen y05 = (year==2005)

. sort city05 y05

. by city05: replace city_name = city_name[_N]
(273 real changes made)

. drop y05

. sort city05 year

. foreach X of varlist a434-c_urb_ob_19to55_h_A2 gdp_pred* gdp_sect2_pred* {
  2. rename `X' `X'_prefa
  3. }

. drop a453_prefa-a874_prefa

. reshape wide a434_prefa-a193_prefa gdp_prefa-a452_prefa c_*_prefa gdp_pred* gdp_
> sect2_pred*, i(city05 city_name) j(year)
(note: j = 1982 1990 1995 2000 2005 2008 2010)

Data                               long   ->   wide
-----------------------------------------------------------------------------
Number of obs.                     2002   ->     286
Number of variables                 378   ->    2627
j variable (7 values)              year   ->   (dropped)
xij variables:
                             a434_prefa   ->   a434_prefa1982 a434_prefa1990 ... a
> 434_prefa2010
                             a431_prefa   ->   a431_prefa1982 a431_prefa1990 ... a
> 431_prefa2010
                             a437_prefa   ->   a437_prefa1982 a437_prefa1990 ... a
> 437_prefa2010
                           aN5006_prefa   ->   aN5006_prefa1982 aN5006_prefa1990 .
> .. aN5006_prefa2010
                             a446_prefa   ->   a446_prefa1982 a446_prefa1990 ... a
> 446_prefa2010
                             a449_prefa   ->   a449_prefa1982 a449_prefa1990 ... a
> 449_prefa2010
                             a451_prefa   ->   a451_prefa1982 a451_prefa1990 ... a
> 451_prefa2010
                             a381_prefa   ->   a381_prefa1982 a381_prefa1990 ... a
> 381_prefa2010
                           aN6003_prefa   ->   aN6003_prefa1982 aN6003_prefa1990 .
> .. aN6003_prefa2010
                           aN6004_prefa   ->   aN6004_prefa1982 aN6004_prefa1990 .
> .. aN6004_prefa2010
                           aN6005_prefa   ->   aN6005_prefa1982 aN6005_prefa1990 .
> .. aN6005_prefa2010
                           aN6006_prefa   ->   aN6006_prefa1982 aN6006_prefa1990 .
> .. aN6006_prefa2010
                           aN6007_prefa   ->   aN6007_prefa1982 aN6007_prefa1990 .
> .. aN6007_prefa2010
                           aN6008_prefa   ->   aN6008_prefa1982 aN6008_prefa1990 .
> .. aN6008_prefa2010
                           aN6009_prefa   ->   aN6009_prefa1982 aN6009_prefa1990 .
> .. aN6009_prefa2010
                           aN6010_prefa   ->   aN6010_prefa1982 aN6010_prefa1990 .
> .. aN6010_prefa2010
                           aN6011_prefa   ->   aN6011_prefa1982 aN6011_prefa1990 .
> .. aN6011_prefa2010
                           aN6012_prefa   ->   aN6012_prefa1982 aN6012_prefa1990 .
> .. aN6012_prefa2010
                           aN6013_prefa   ->   aN6013_prefa1982 aN6013_prefa1990 .
> .. aN6013_prefa2010
                           aN6014_prefa   ->   aN6014_prefa1982 aN6014_prefa1990 .
> .. aN6014_prefa2010
                           aN6015_prefa   ->   aN6015_prefa1982 aN6015_prefa1990 .
> .. aN6015_prefa2010
                           aN6016_prefa   ->   aN6016_prefa1982 aN6016_prefa1990 .
> .. aN6016_prefa2010
                           aN6017_prefa   ->   aN6017_prefa1982 aN6017_prefa1990 .
> .. aN6017_prefa2010
                           aN6018_prefa   ->   aN6018_prefa1982 aN6018_prefa1990 .
> .. aN6018_prefa2010
                           aN6019_prefa   ->   aN6019_prefa1982 aN6019_prefa1990 .
> .. aN6019_prefa2010
                           aN6020_prefa   ->   aN6020_prefa1982 aN6020_prefa1990 .
> .. aN6020_prefa2010
                           aN6021_prefa   ->   aN6021_prefa1982 aN6021_prefa1990 .
> .. aN6021_prefa2010
                           aN6022_prefa   ->   aN6022_prefa1982 aN6022_prefa1990 .
> .. aN6022_prefa2010
                             a102_prefa   ->   a102_prefa1982 a102_prefa1990 ... a
> 102_prefa2010
                             a103_prefa   ->   a103_prefa1982 a103_prefa1990 ... a
> 103_prefa2010
                             a104_prefa   ->   a104_prefa1982 a104_prefa1990 ... a
> 104_prefa2010
                             a117_prefa   ->   a117_prefa1982 a117_prefa1990 ... a
> 117_prefa2010
                             a120_prefa   ->   a120_prefa1982 a120_prefa1990 ... a
> 120_prefa2010
                             a188_prefa   ->   a188_prefa1982 a188_prefa1990 ... a
> 188_prefa2010
                             a189_prefa   ->   a189_prefa1982 a189_prefa1990 ... a
> 189_prefa2010
                             a191_prefa   ->   a191_prefa1982 a191_prefa1990 ... a
> 191_prefa2010
                             a192_prefa   ->   a192_prefa1982 a192_prefa1990 ... a
> 192_prefa2010
                             a194_prefa   ->   a194_prefa1982 a194_prefa1990 ... a
> 194_prefa2010
                             a195_prefa   ->   a195_prefa1982 a195_prefa1990 ... a
> 195_prefa2010
                           aN3012_prefa   ->   aN3012_prefa1982 aN3012_prefa1990 .
> .. aN3012_prefa2010
                           aN3013_prefa   ->   aN3013_prefa1982 aN3013_prefa1990 .
> .. aN3013_prefa2010
                           aN3014_prefa   ->   aN3014_prefa1982 aN3014_prefa1990 .
> .. aN3014_prefa2010
                             a280_prefa   ->   a280_prefa1982 a280_prefa1990 ... a
> 280_prefa2010
                             a281_prefa   ->   a281_prefa1982 a281_prefa1990 ... a
> 281_prefa2010
                             a277_prefa   ->   a277_prefa1982 a277_prefa1990 ... a
> 277_prefa2010
                             a278_prefa   ->   a278_prefa1982 a278_prefa1990 ... a
> 278_prefa2010
                         a271_274_prefa   ->   a271_274_prefa1982 a271_274_prefa19
> 90 ... a271_274_prefa2010
                         a272_275_prefa   ->   a272_275_prefa1982 a272_275_prefa19
> 90 ... a272_275_prefa2010
                             a268_prefa   ->   a268_prefa1982 a268_prefa1990 ... a
> 268_prefa2010
                             a269_prefa   ->   a269_prefa1982 a269_prefa1990 ... a
> 269_prefa2010
                             a265_prefa   ->   a265_prefa1982 a265_prefa1990 ... a
> 265_prefa2010
                             a266_prefa   ->   a266_prefa1982 a266_prefa1990 ... a
> 266_prefa2010
                           aN4013_prefa   ->   aN4013_prefa1982 aN4013_prefa1990 .
> .. aN4013_prefa2010
                             a185_prefa   ->   a185_prefa1982 a185_prefa1990 ... a
> 185_prefa2010
                             a186_prefa   ->   a186_prefa1982 a186_prefa1990 ... a
> 186_prefa2010
                     aN_m_55older_prefa   ->   aN_m_55older_prefa1982 aN_m_55older
> _prefa1990 ... aN_m_55older_prefa2010
                     aN_f_55older_prefa   ->   aN_f_55older_prefa1982 aN_f_55older
> _prefa1990 ... aN_f_55older_prefa2010
                     aN_t_55older_prefa   ->   aN_t_55older_prefa1982 aN_t_55older
> _prefa1990 ... aN_t_55older_prefa2010
                             a184_prefa   ->   a184_prefa1982 a184_prefa1990 ... a
> 184_prefa2010
                             a187_prefa   ->   a187_prefa1982 a187_prefa1990 ... a
> 187_prefa2010
                             a190_prefa   ->   a190_prefa1982 a190_prefa1990 ... a
> 190_prefa2010
                             a193_prefa   ->   a193_prefa1982 a193_prefa1990 ... a
> 193_prefa2010
                              gdp_prefa   ->   gdp_prefa1982 gdp_prefa1990 ... gdp
> _prefa2010
                      gdp_sector1_prefa   ->   gdp_sector1_prefa1982 gdp_sector1_p
> refa1990 ... gdp_sector1_prefa2010
                      gdp_sector2_prefa   ->   gdp_sector2_prefa1982 gdp_sector2_p
> refa1990 ... gdp_sector2_prefa2010
                      gdp_sector3_prefa   ->   gdp_sector3_prefa1982 gdp_sector3_p
> refa1990 ... gdp_sector3_prefa2010
                          tot_pop_prefa   ->   tot_pop_prefa1982 tot_pop_prefa1990
>  ... tot_pop_prefa2010
                      arrived_fdi_prefa   ->   arrived_fdi_prefa1982 arrived_fdi_p
> refa1990 ... arrived_fdi_prefa2010
                              pop_prefa   ->   pop_prefa1982 pop_prefa1990 ... pop
> _prefa2010
                     gdp_michigan_prefa   ->   gdp_michigan_prefa1982 gdp_michigan
> _prefa1990 ... gdp_michigan_prefa2010
               avgsalary_michigan_prefa   ->   avgsalary_michigan_prefa1982 avgsal
> ary_michigan_prefa1990 ... avgsalary_michigan_prefa2010
                 area_paved_roads_prefa   ->   area_paved_roads_prefa1982 area_pav
> ed_roads_prefa1990 ... area_paved_roads_prefa2010
                           agr_mp_prefa   ->   agr_mp_prefa1982 agr_mp_prefa1990 .
> .. agr_mp_prefa2010
                              apr_prefa   ->   apr_prefa1982 apr_prefa1990 ... apr
> _prefa2010
                        avgsalary_prefa   ->   avgsalary_prefa1982 avgsalary_prefa
> 1990 ... avgsalary_prefa2010
                             area_prefa   ->   area_prefa1982 area_prefa1990 ... a
> rea_prefa2010
                           agr_rl_prefa   ->   agr_rl_prefa1982 agr_rl_prefa1990 .
> .. agr_rl_prefa2010
                   agr_mp_fenxian_prefa   ->   agr_mp_fenxian_prefa1982 agr_mp_fen
> xian_prefa1990 ... agr_mp_fenxian_prefa2010
                       asset_g_qz_prefa   ->   asset_g_qz_prefa1982 asset_g_qz_pre
> fa1990 ... asset_g_qz_prefa2010
                       asset_n_qz_prefa   ->   asset_n_qz_prefa1982 asset_n_qz_pre
> fa1990 ... asset_n_qz_prefa2010
                             a101_prefa   ->   a101_prefa1982 a101_prefa1990 ... a
> 101_prefa2010
                             a105_prefa   ->   a105_prefa1982 a105_prefa1990 ... a
> 105_prefa2010
                             a106_prefa   ->   a106_prefa1982 a106_prefa1990 ... a
> 106_prefa2010
                             a107_prefa   ->   a107_prefa1982 a107_prefa1990 ... a
> 107_prefa2010
                             a108_prefa   ->   a108_prefa1982 a108_prefa1990 ... a
> 108_prefa2010
                             a109_prefa   ->   a109_prefa1982 a109_prefa1990 ... a
> 109_prefa2010
                             a110_prefa   ->   a110_prefa1982 a110_prefa1990 ... a
> 110_prefa2010
                             a111_prefa   ->   a111_prefa1982 a111_prefa1990 ... a
> 111_prefa2010
                             a112_prefa   ->   a112_prefa1982 a112_prefa1990 ... a
> 112_prefa2010
                             a113_prefa   ->   a113_prefa1982 a113_prefa1990 ... a
> 113_prefa2010
                             a114_prefa   ->   a114_prefa1982 a114_prefa1990 ... a
> 114_prefa2010
                             a115_prefa   ->   a115_prefa1982 a115_prefa1990 ... a
> 115_prefa2010
                             a116_prefa   ->   a116_prefa1982 a116_prefa1990 ... a
> 116_prefa2010
                             a118_prefa   ->   a118_prefa1982 a118_prefa1990 ... a
> 118_prefa2010
                             a119_prefa   ->   a119_prefa1982 a119_prefa1990 ... a
> 119_prefa2010
                             a121_prefa   ->   a121_prefa1982 a121_prefa1990 ... a
> 121_prefa2010
                             a122_prefa   ->   a122_prefa1982 a122_prefa1990 ... a
> 122_prefa2010
                             a123_prefa   ->   a123_prefa1982 a123_prefa1990 ... a
> 123_prefa2010
                             a124_prefa   ->   a124_prefa1982 a124_prefa1990 ... a
> 124_prefa2010
                             a125_prefa   ->   a125_prefa1982 a125_prefa1990 ... a
> 125_prefa2010
                             a126_prefa   ->   a126_prefa1982 a126_prefa1990 ... a
> 126_prefa2010
                             a127_prefa   ->   a127_prefa1982 a127_prefa1990 ... a
> 127_prefa2010
                             a128_prefa   ->   a128_prefa1982 a128_prefa1990 ... a
> 128_prefa2010
                             a129_prefa   ->   a129_prefa1982 a129_prefa1990 ... a
> 129_prefa2010
                             a130_prefa   ->   a130_prefa1982 a130_prefa1990 ... a
> 130_prefa2010
                             a131_prefa   ->   a131_prefa1982 a131_prefa1990 ... a
> 131_prefa2010
                             a132_prefa   ->   a132_prefa1982 a132_prefa1990 ... a
> 132_prefa2010
                             a133_prefa   ->   a133_prefa1982 a133_prefa1990 ... a
> 133_prefa2010
                             a134_prefa   ->   a134_prefa1982 a134_prefa1990 ... a
> 134_prefa2010
                             a135_prefa   ->   a135_prefa1982 a135_prefa1990 ... a
> 135_prefa2010
                             a136_prefa   ->   a136_prefa1982 a136_prefa1990 ... a
> 136_prefa2010
                             a137_prefa   ->   a137_prefa1982 a137_prefa1990 ... a
> 137_prefa2010
                             a138_prefa   ->   a138_prefa1982 a138_prefa1990 ... a
> 138_prefa2010
                             a139_prefa   ->   a139_prefa1982 a139_prefa1990 ... a
> 139_prefa2010
                             a140_prefa   ->   a140_prefa1982 a140_prefa1990 ... a
> 140_prefa2010
                             a141_prefa   ->   a141_prefa1982 a141_prefa1990 ... a
> 141_prefa2010
                             a142_prefa   ->   a142_prefa1982 a142_prefa1990 ... a
> 142_prefa2010
                             a143_prefa   ->   a143_prefa1982 a143_prefa1990 ... a
> 143_prefa2010
                             a144_prefa   ->   a144_prefa1982 a144_prefa1990 ... a
> 144_prefa2010
                             a145_prefa   ->   a145_prefa1982 a145_prefa1990 ... a
> 145_prefa2010
                             a146_prefa   ->   a146_prefa1982 a146_prefa1990 ... a
> 146_prefa2010
                             a181_prefa   ->   a181_prefa1982 a181_prefa1990 ... a
> 181_prefa2010
                             a182_prefa   ->   a182_prefa1982 a182_prefa1990 ... a
> 182_prefa2010
                             a183_prefa   ->   a183_prefa1982 a183_prefa1990 ... a
> 183_prefa2010
                             a196_prefa   ->   a196_prefa1982 a196_prefa1990 ... a
> 196_prefa2010
                             a197_prefa   ->   a197_prefa1982 a197_prefa1990 ... a
> 197_prefa2010
                             a198_prefa   ->   a198_prefa1982 a198_prefa1990 ... a
> 198_prefa2010
                             a199_prefa   ->   a199_prefa1982 a199_prefa1990 ... a
> 199_prefa2010
                             a200_prefa   ->   a200_prefa1982 a200_prefa1990 ... a
> 200_prefa2010
                             a201_prefa   ->   a201_prefa1982 a201_prefa1990 ... a
> 201_prefa2010
                             a202_prefa   ->   a202_prefa1982 a202_prefa1990 ... a
> 202_prefa2010
                             a203_prefa   ->   a203_prefa1982 a203_prefa1990 ... a
> 203_prefa2010
                             a204_prefa   ->   a204_prefa1982 a204_prefa1990 ... a
> 204_prefa2010
                             a205_prefa   ->   a205_prefa1982 a205_prefa1990 ... a
> 205_prefa2010
                             a206_prefa   ->   a206_prefa1982 a206_prefa1990 ... a
> 206_prefa2010
                             a207_prefa   ->   a207_prefa1982 a207_prefa1990 ... a
> 207_prefa2010
                             a208_prefa   ->   a208_prefa1982 a208_prefa1990 ... a
> 208_prefa2010
                             a209_prefa   ->   a209_prefa1982 a209_prefa1990 ... a
> 209_prefa2010
                             a210_prefa   ->   a210_prefa1982 a210_prefa1990 ... a
> 210_prefa2010
                             a211_prefa   ->   a211_prefa1982 a211_prefa1990 ... a
> 211_prefa2010
                             a212_prefa   ->   a212_prefa1982 a212_prefa1990 ... a
> 212_prefa2010
                             a213_prefa   ->   a213_prefa1982 a213_prefa1990 ... a
> 213_prefa2010
                             a214_prefa   ->   a214_prefa1982 a214_prefa1990 ... a
> 214_prefa2010
                             a215_prefa   ->   a215_prefa1982 a215_prefa1990 ... a
> 215_prefa2010
                             a216_prefa   ->   a216_prefa1982 a216_prefa1990 ... a
> 216_prefa2010
                             a217_prefa   ->   a217_prefa1982 a217_prefa1990 ... a
> 217_prefa2010
                             a218_prefa   ->   a218_prefa1982 a218_prefa1990 ... a
> 218_prefa2010
                             a219_prefa   ->   a219_prefa1982 a219_prefa1990 ... a
> 219_prefa2010
                             a220_prefa   ->   a220_prefa1982 a220_prefa1990 ... a
> 220_prefa2010
                             a221_prefa   ->   a221_prefa1982 a221_prefa1990 ... a
> 221_prefa2010
                             a222_prefa   ->   a222_prefa1982 a222_prefa1990 ... a
> 222_prefa2010
                             a223_prefa   ->   a223_prefa1982 a223_prefa1990 ... a
> 223_prefa2010
                             a224_prefa   ->   a224_prefa1982 a224_prefa1990 ... a
> 224_prefa2010
                             a225_prefa   ->   a225_prefa1982 a225_prefa1990 ... a
> 225_prefa2010
                             a226_prefa   ->   a226_prefa1982 a226_prefa1990 ... a
> 226_prefa2010
                             a227_prefa   ->   a227_prefa1982 a227_prefa1990 ... a
> 227_prefa2010
                             a228_prefa   ->   a228_prefa1982 a228_prefa1990 ... a
> 228_prefa2010
                             a229_prefa   ->   a229_prefa1982 a229_prefa1990 ... a
> 229_prefa2010
                             a230_prefa   ->   a230_prefa1982 a230_prefa1990 ... a
> 230_prefa2010
                             a231_prefa   ->   a231_prefa1982 a231_prefa1990 ... a
> 231_prefa2010
                             a232_prefa   ->   a232_prefa1982 a232_prefa1990 ... a
> 232_prefa2010
                             a233_prefa   ->   a233_prefa1982 a233_prefa1990 ... a
> 233_prefa2010
                             a234_prefa   ->   a234_prefa1982 a234_prefa1990 ... a
> 234_prefa2010
                             a235_prefa   ->   a235_prefa1982 a235_prefa1990 ... a
> 235_prefa2010
                             a236_prefa   ->   a236_prefa1982 a236_prefa1990 ... a
> 236_prefa2010
                             a237_prefa   ->   a237_prefa1982 a237_prefa1990 ... a
> 237_prefa2010
                             a238_prefa   ->   a238_prefa1982 a238_prefa1990 ... a
> 238_prefa2010
                             a239_prefa   ->   a239_prefa1982 a239_prefa1990 ... a
> 239_prefa2010
                             a240_prefa   ->   a240_prefa1982 a240_prefa1990 ... a
> 240_prefa2010
                             a241_prefa   ->   a241_prefa1982 a241_prefa1990 ... a
> 241_prefa2010
                             a242_prefa   ->   a242_prefa1982 a242_prefa1990 ... a
> 242_prefa2010
                             a243_prefa   ->   a243_prefa1982 a243_prefa1990 ... a
> 243_prefa2010
                             a244_prefa   ->   a244_prefa1982 a244_prefa1990 ... a
> 244_prefa2010
                             a245_prefa   ->   a245_prefa1982 a245_prefa1990 ... a
> 245_prefa2010
                             a246_prefa   ->   a246_prefa1982 a246_prefa1990 ... a
> 246_prefa2010
                             a261_prefa   ->   a261_prefa1982 a261_prefa1990 ... a
> 261_prefa2010
                             a262_prefa   ->   a262_prefa1982 a262_prefa1990 ... a
> 262_prefa2010
                             a263_prefa   ->   a263_prefa1982 a263_prefa1990 ... a
> 263_prefa2010
                             a264_prefa   ->   a264_prefa1982 a264_prefa1990 ... a
> 264_prefa2010
                             a267_prefa   ->   a267_prefa1982 a267_prefa1990 ... a
> 267_prefa2010
                             a270_prefa   ->   a270_prefa1982 a270_prefa1990 ... a
> 270_prefa2010
                             a271_prefa   ->   a271_prefa1982 a271_prefa1990 ... a
> 271_prefa2010
                             a272_prefa   ->   a272_prefa1982 a272_prefa1990 ... a
> 272_prefa2010
                             a273_prefa   ->   a273_prefa1982 a273_prefa1990 ... a
> 273_prefa2010
                             a274_prefa   ->   a274_prefa1982 a274_prefa1990 ... a
> 274_prefa2010
                             a275_prefa   ->   a275_prefa1982 a275_prefa1990 ... a
> 275_prefa2010
                             a276_prefa   ->   a276_prefa1982 a276_prefa1990 ... a
> 276_prefa2010
                             a279_prefa   ->   a279_prefa1982 a279_prefa1990 ... a
> 279_prefa2010
                             a282_prefa   ->   a282_prefa1982 a282_prefa1990 ... a
> 282_prefa2010
                             a283_prefa   ->   a283_prefa1982 a283_prefa1990 ... a
> 283_prefa2010
                             a284_prefa   ->   a284_prefa1982 a284_prefa1990 ... a
> 284_prefa2010
                             a291_prefa   ->   a291_prefa1982 a291_prefa1990 ... a
> 291_prefa2010
                             a292_prefa   ->   a292_prefa1982 a292_prefa1990 ... a
> 292_prefa2010
                             a293_prefa   ->   a293_prefa1982 a293_prefa1990 ... a
> 293_prefa2010
                             a294_prefa   ->   a294_prefa1982 a294_prefa1990 ... a
> 294_prefa2010
                             a295_prefa   ->   a295_prefa1982 a295_prefa1990 ... a
> 295_prefa2010
                             a296_prefa   ->   a296_prefa1982 a296_prefa1990 ... a
> 296_prefa2010
                             a301_prefa   ->   a301_prefa1982 a301_prefa1990 ... a
> 301_prefa2010
                             a302_prefa   ->   a302_prefa1982 a302_prefa1990 ... a
> 302_prefa2010
                             a303_prefa   ->   a303_prefa1982 a303_prefa1990 ... a
> 303_prefa2010
                             a304_prefa   ->   a304_prefa1982 a304_prefa1990 ... a
> 304_prefa2010
                             a305_prefa   ->   a305_prefa1982 a305_prefa1990 ... a
> 305_prefa2010
                             a306_prefa   ->   a306_prefa1982 a306_prefa1990 ... a
> 306_prefa2010
                             a307_prefa   ->   a307_prefa1982 a307_prefa1990 ... a
> 307_prefa2010
                             a308_prefa   ->   a308_prefa1982 a308_prefa1990 ... a
> 308_prefa2010
                             a309_prefa   ->   a309_prefa1982 a309_prefa1990 ... a
> 309_prefa2010
                             a310_prefa   ->   a310_prefa1982 a310_prefa1990 ... a
> 310_prefa2010
                             a311_prefa   ->   a311_prefa1982 a311_prefa1990 ... a
> 311_prefa2010
                             a312_prefa   ->   a312_prefa1982 a312_prefa1990 ... a
> 312_prefa2010
                             a313_prefa   ->   a313_prefa1982 a313_prefa1990 ... a
> 313_prefa2010
                             a314_prefa   ->   a314_prefa1982 a314_prefa1990 ... a
> 314_prefa2010
                             a315_prefa   ->   a315_prefa1982 a315_prefa1990 ... a
> 315_prefa2010
                             a321_prefa   ->   a321_prefa1982 a321_prefa1990 ... a
> 321_prefa2010
                             a322_prefa   ->   a322_prefa1982 a322_prefa1990 ... a
> 322_prefa2010
                             a323_prefa   ->   a323_prefa1982 a323_prefa1990 ... a
> 323_prefa2010
                             a324_prefa   ->   a324_prefa1982 a324_prefa1990 ... a
> 324_prefa2010
                             a325_prefa   ->   a325_prefa1982 a325_prefa1990 ... a
> 325_prefa2010
                             a326_prefa   ->   a326_prefa1982 a326_prefa1990 ... a
> 326_prefa2010
                             a327_prefa   ->   a327_prefa1982 a327_prefa1990 ... a
> 327_prefa2010
                             a328_prefa   ->   a328_prefa1982 a328_prefa1990 ... a
> 328_prefa2010
                             a329_prefa   ->   a329_prefa1982 a329_prefa1990 ... a
> 329_prefa2010
                             a330_prefa   ->   a330_prefa1982 a330_prefa1990 ... a
> 330_prefa2010
                             a331_prefa   ->   a331_prefa1982 a331_prefa1990 ... a
> 331_prefa2010
                             a332_prefa   ->   a332_prefa1982 a332_prefa1990 ... a
> 332_prefa2010
                             a341_prefa   ->   a341_prefa1982 a341_prefa1990 ... a
> 341_prefa2010
                             a342_prefa   ->   a342_prefa1982 a342_prefa1990 ... a
> 342_prefa2010
                             a343_prefa   ->   a343_prefa1982 a343_prefa1990 ... a
> 343_prefa2010
                             a344_prefa   ->   a344_prefa1982 a344_prefa1990 ... a
> 344_prefa2010
                             a345_prefa   ->   a345_prefa1982 a345_prefa1990 ... a
> 345_prefa2010
                             a346_prefa   ->   a346_prefa1982 a346_prefa1990 ... a
> 346_prefa2010
                             a347_prefa   ->   a347_prefa1982 a347_prefa1990 ... a
> 347_prefa2010
                             a348_prefa   ->   a348_prefa1982 a348_prefa1990 ... a
> 348_prefa2010
                             a349_prefa   ->   a349_prefa1982 a349_prefa1990 ... a
> 349_prefa2010
                             a350_prefa   ->   a350_prefa1982 a350_prefa1990 ... a
> 350_prefa2010
                             a351_prefa   ->   a351_prefa1982 a351_prefa1990 ... a
> 351_prefa2010
                             a352_prefa   ->   a352_prefa1982 a352_prefa1990 ... a
> 352_prefa2010
                             a361_prefa   ->   a361_prefa1982 a361_prefa1990 ... a
> 361_prefa2010
                             a362_prefa   ->   a362_prefa1982 a362_prefa1990 ... a
> 362_prefa2010
                             a363_prefa   ->   a363_prefa1982 a363_prefa1990 ... a
> 363_prefa2010
                             a364_prefa   ->   a364_prefa1982 a364_prefa1990 ... a
> 364_prefa2010
                             a365_prefa   ->   a365_prefa1982 a365_prefa1990 ... a
> 365_prefa2010
                             a366_prefa   ->   a366_prefa1982 a366_prefa1990 ... a
> 366_prefa2010
                             a367_prefa   ->   a367_prefa1982 a367_prefa1990 ... a
> 367_prefa2010
                             a368_prefa   ->   a368_prefa1982 a368_prefa1990 ... a
> 368_prefa2010
                             a369_prefa   ->   a369_prefa1982 a369_prefa1990 ... a
> 369_prefa2010
                             a370_prefa   ->   a370_prefa1982 a370_prefa1990 ... a
> 370_prefa2010
                             a382_prefa   ->   a382_prefa1982 a382_prefa1990 ... a
> 382_prefa2010
                             a383_prefa   ->   a383_prefa1982 a383_prefa1990 ... a
> 383_prefa2010
                             a384_prefa   ->   a384_prefa1982 a384_prefa1990 ... a
> 384_prefa2010
                             a385_prefa   ->   a385_prefa1982 a385_prefa1990 ... a
> 385_prefa2010
                             a386_prefa   ->   a386_prefa1982 a386_prefa1990 ... a
> 386_prefa2010
                             a387_prefa   ->   a387_prefa1982 a387_prefa1990 ... a
> 387_prefa2010
                             a388_prefa   ->   a388_prefa1982 a388_prefa1990 ... a
> 388_prefa2010
                             a389_prefa   ->   a389_prefa1982 a389_prefa1990 ... a
> 389_prefa2010
                             a390_prefa   ->   a390_prefa1982 a390_prefa1990 ... a
> 390_prefa2010
                             a391_prefa   ->   a391_prefa1982 a391_prefa1990 ... a
> 391_prefa2010
                             a392_prefa   ->   a392_prefa1982 a392_prefa1990 ... a
> 392_prefa2010
                             a393_prefa   ->   a393_prefa1982 a393_prefa1990 ... a
> 393_prefa2010
                             a394_prefa   ->   a394_prefa1982 a394_prefa1990 ... a
> 394_prefa2010
                             a395_prefa   ->   a395_prefa1982 a395_prefa1990 ... a
> 395_prefa2010
                             a396_prefa   ->   a396_prefa1982 a396_prefa1990 ... a
> 396_prefa2010
                             a397_prefa   ->   a397_prefa1982 a397_prefa1990 ... a
> 397_prefa2010
                             a398_prefa   ->   a398_prefa1982 a398_prefa1990 ... a
> 398_prefa2010
                             a399_prefa   ->   a399_prefa1982 a399_prefa1990 ... a
> 399_prefa2010
                             a400_prefa   ->   a400_prefa1982 a400_prefa1990 ... a
> 400_prefa2010
                             a401_prefa   ->   a401_prefa1982 a401_prefa1990 ... a
> 401_prefa2010
                             a402_prefa   ->   a402_prefa1982 a402_prefa1990 ... a
> 402_prefa2010
                             a403_prefa   ->   a403_prefa1982 a403_prefa1990 ... a
> 403_prefa2010
                             a404_prefa   ->   a404_prefa1982 a404_prefa1990 ... a
> 404_prefa2010
                             a405_prefa   ->   a405_prefa1982 a405_prefa1990 ... a
> 405_prefa2010
                             a406_prefa   ->   a406_prefa1982 a406_prefa1990 ... a
> 406_prefa2010
                             a407_prefa   ->   a407_prefa1982 a407_prefa1990 ... a
> 407_prefa2010
                             a408_prefa   ->   a408_prefa1982 a408_prefa1990 ... a
> 408_prefa2010
                             a409_prefa   ->   a409_prefa1982 a409_prefa1990 ... a
> 409_prefa2010
                             a410_prefa   ->   a410_prefa1982 a410_prefa1990 ... a
> 410_prefa2010
                             a411_prefa   ->   a411_prefa1982 a411_prefa1990 ... a
> 411_prefa2010
                             a412_prefa   ->   a412_prefa1982 a412_prefa1990 ... a
> 412_prefa2010
                             a413_prefa   ->   a413_prefa1982 a413_prefa1990 ... a
> 413_prefa2010
                             a414_prefa   ->   a414_prefa1982 a414_prefa1990 ... a
> 414_prefa2010
                             a415_prefa   ->   a415_prefa1982 a415_prefa1990 ... a
> 415_prefa2010
                             a416_prefa   ->   a416_prefa1982 a416_prefa1990 ... a
> 416_prefa2010
                             a417_prefa   ->   a417_prefa1982 a417_prefa1990 ... a
> 417_prefa2010
                             a418_prefa   ->   a418_prefa1982 a418_prefa1990 ... a
> 418_prefa2010
                             a419_prefa   ->   a419_prefa1982 a419_prefa1990 ... a
> 419_prefa2010
                             a420_prefa   ->   a420_prefa1982 a420_prefa1990 ... a
> 420_prefa2010
                             a421_prefa   ->   a421_prefa1982 a421_prefa1990 ... a
> 421_prefa2010
                             a422_prefa   ->   a422_prefa1982 a422_prefa1990 ... a
> 422_prefa2010
                             a423_prefa   ->   a423_prefa1982 a423_prefa1990 ... a
> 423_prefa2010
                             a424_prefa   ->   a424_prefa1982 a424_prefa1990 ... a
> 424_prefa2010
                             a425_prefa   ->   a425_prefa1982 a425_prefa1990 ... a
> 425_prefa2010
                             a426_prefa   ->   a426_prefa1982 a426_prefa1990 ... a
> 426_prefa2010
                             a427_prefa   ->   a427_prefa1982 a427_prefa1990 ... a
> 427_prefa2010
                             a428_prefa   ->   a428_prefa1982 a428_prefa1990 ... a
> 428_prefa2010
                             a432_prefa   ->   a432_prefa1982 a432_prefa1990 ... a
> 432_prefa2010
                             a433_prefa   ->   a433_prefa1982 a433_prefa1990 ... a
> 433_prefa2010
                             a435_prefa   ->   a435_prefa1982 a435_prefa1990 ... a
> 435_prefa2010
                             a436_prefa   ->   a436_prefa1982 a436_prefa1990 ... a
> 436_prefa2010
                             a438_prefa   ->   a438_prefa1982 a438_prefa1990 ... a
> 438_prefa2010
                             a439_prefa   ->   a439_prefa1982 a439_prefa1990 ... a
> 439_prefa2010
                             a440_prefa   ->   a440_prefa1982 a440_prefa1990 ... a
> 440_prefa2010
                             a441_prefa   ->   a441_prefa1982 a441_prefa1990 ... a
> 441_prefa2010
                             a442_prefa   ->   a442_prefa1982 a442_prefa1990 ... a
> 442_prefa2010
                             a443_prefa   ->   a443_prefa1982 a443_prefa1990 ... a
> 443_prefa2010
                             a444_prefa   ->   a444_prefa1982 a444_prefa1990 ... a
> 444_prefa2010
                             a445_prefa   ->   a445_prefa1982 a445_prefa1990 ... a
> 445_prefa2010
                             a447_prefa   ->   a447_prefa1982 a447_prefa1990 ... a
> 447_prefa2010
                             a448_prefa   ->   a448_prefa1982 a448_prefa1990 ... a
> 448_prefa2010
                             a450_prefa   ->   a450_prefa1982 a450_prefa1990 ... a
> 450_prefa2010
                             a452_prefa   ->   a452_prefa1982 a452_prefa1990 ... a
> 452_prefa2010
                       c_totalPop_prefa   ->   c_totalPop_prefa1982 c_totalPop_pre
> fa1990 ... c_totalPop_prefa2010
                            c_emp_prefa   ->   c_emp_prefa1982 c_emp_prefa1990 ...
>  c_emp_prefa2010
                         c_emp_ag_prefa   ->   c_emp_ag_prefa1982 c_emp_ag_prefa19
> 90 ... c_emp_ag_prefa2010
                        c_emp_min_prefa   ->   c_emp_min_prefa1982 c_emp_min_prefa
> 1990 ... c_emp_min_prefa2010
                        c_emp_man_prefa   ->   c_emp_man_prefa1982 c_emp_man_prefa
> 1990 ... c_emp_man_prefa2010
                   c_emp_man_trad_prefa   ->   c_emp_man_trad_prefa1982 c_emp_man_
> trad_prefa1990 ... c_emp_man_trad_prefa2010
                   c_emp_man_chem_prefa   ->   c_emp_man_chem_prefa1982 c_emp_man_
> chem_prefa1990 ... c_emp_man_chem_prefa2010
                    c_emp_man_hvy_prefa   ->   c_emp_man_hvy_prefa1982 c_emp_man_h
> vy_prefa1990 ... c_emp_man_hvy_prefa2010
                 c_emp_man_hitech_prefa   ->   c_emp_man_hitech_prefa1982 c_emp_ma
> n_hitech_prefa1990 ... c_emp_man_hitech_prefa2010
                       c_emp_util_prefa   ->   c_emp_util_prefa1982 c_emp_util_pre
> fa1990 ... c_emp_util_prefa2010
                       c_emp_cons_prefa   ->   c_emp_cons_prefa1982 c_emp_cons_pre
> fa1990 ... c_emp_cons_prefa2010
                       c_emp_soft_prefa   ->   c_emp_soft_prefa1982 c_emp_soft_pre
> fa1990 ... c_emp_soft_prefa2010
                       c_emp_whsl_prefa   ->   c_emp_whsl_prefa1982 c_emp_whsl_pre
> fa1990 ... c_emp_whsl_prefa2010
                       c_emp_fina_prefa   ->   c_emp_fina_prefa1982 c_emp_fina_pre
> fa1990 ... c_emp_fina_prefa2010
                        c_emp_res_prefa   ->   c_emp_res_prefa1982 c_emp_res_prefa
> 1990 ... c_emp_res_prefa2010
                        c_emp_cul_prefa   ->   c_emp_cul_prefa1982 c_emp_cul_prefa
> 1990 ... c_emp_cul_prefa2010
                        c_emp_pub_prefa   ->   c_emp_pub_prefa1982 c_emp_pub_prefa
> 1990 ... c_emp_pub_prefa2010
                       c_emp_tran_prefa   ->   c_emp_tran_prefa1982 c_emp_tran_pre
> fa1990 ... c_emp_tran_prefa2010
                        c_rur_Mig_prefa   ->   c_rur_Mig_prefa1982 c_rur_Mig_prefa
> 1990 ... c_rur_Mig_prefa2010
                        c_urb_Mig_prefa   ->   c_urb_Mig_prefa1982 c_urb_Mig_prefa
> 1990 ... c_urb_Mig_prefa2010
                c_rur_mig_19to55__prefa   ->   c_rur_mig_19to55__prefa1982 c_rur_m
> ig_19to55__prefa1990 ... c_rur_mig_19to55__prefa2010
               c_rur_mig_19to55_h_prefa   ->   c_rur_mig_19to55_h_prefa1982 c_rur_
> mig_19to55_h_prefa1990 ... c_rur_mig_19to55_h_prefa2010
                c_urb_mig_19to55__prefa   ->   c_urb_mig_19to55__prefa1982 c_urb_m
> ig_19to55__prefa1990 ... c_urb_mig_19to55__prefa2010
               c_urb_mig_19to55_h_prefa   ->   c_urb_mig_19to55_h_prefa1982 c_urb_
> mig_19to55_h_prefa1990 ... c_urb_mig_19to55_h_prefa2010
                       c_f_19to55_prefa   ->   c_f_19to55_prefa1982 c_f_19to55_pre
> fa1990 ... c_f_19to55_prefa2010
                      c_f_Under19_prefa   ->   c_f_Under19_prefa1982 c_f_Under19_p
> refa1990 ... c_f_Under19_prefa2010
                       c_f_Over55_prefa   ->   c_f_Over55_prefa1982 c_f_Over55_pre
> fa1990 ... c_f_Over55_prefa2010
                     c_f_19to55_h_prefa   ->   c_f_19to55_h_prefa1982 c_f_19to55_h
> _prefa1990 ... c_f_19to55_h_prefa2010
                    c_f_19to55_w__prefa   ->   c_f_19to55_w__prefa1982 c_f_19to55_
> w__prefa1990 ... c_f_19to55_w__prefa2010
                   c_f_19to55_w_h_prefa   ->   c_f_19to55_w_h_prefa1982 c_f_19to55
> _w_h_prefa1990 ... c_f_19to55_w_h_prefa2010
                   c_f_19to55_w_c_prefa   ->   c_f_19to55_w_c_prefa1982 c_f_19to55
> _w_c_prefa1990 ... c_f_19to55_w_c_prefa2010
                       c_m_19to55_prefa   ->   c_m_19to55_prefa1982 c_m_19to55_pre
> fa1990 ... c_m_19to55_prefa2010
                      c_m_Under19_prefa   ->   c_m_Under19_prefa1982 c_m_Under19_p
> refa1990 ... c_m_Under19_prefa2010
                       c_m_Over55_prefa   ->   c_m_Over55_prefa1982 c_m_Over55_pre
> fa1990 ... c_m_Over55_prefa2010
                     c_m_19to55_h_prefa   ->   c_m_19to55_h_prefa1982 c_m_19to55_h
> _prefa1990 ... c_m_19to55_h_prefa2010
                    c_m_19to55_w__prefa   ->   c_m_19to55_w__prefa1982 c_m_19to55_
> w__prefa1990 ... c_m_19to55_w__prefa2010
                   c_m_19to55_w_h_prefa   ->   c_m_19to55_w_h_prefa1982 c_m_19to55
> _w_h_prefa1990 ... c_m_19to55_w_h_prefa2010
                   c_m_19to55_w_c_prefa   ->   c_m_19to55_w_c_prefa1982 c_m_19to55
> _w_c_prefa1990 ... c_m_19to55_w_c_prefa2010
                      c_rur_mig_A_prefa   ->   c_rur_mig_A_prefa1982 c_rur_mig_A_p
> refa1990 ... c_rur_mig_A_prefa2010
                      c_urb_mig_A_prefa   ->   c_urb_mig_A_prefa1982 c_urb_mig_A_p
> refa1990 ... c_urb_mig_A_prefa2010
               c_rur_mig_19to55_A_prefa   ->   c_rur_mig_19to55_A_prefa1982 c_rur_
> mig_19to55_A_prefa1990 ... c_rur_mig_19to55_A_prefa2010
             c_rur_mig_19to55_h_A_prefa   ->   c_rur_mig_19to55_h_A_prefa1982 c_ru
> r_mig_19to55_h_A_prefa1990 ... c_rur_mig_19to55_h_A_prefa2010
               c_urb_mig_19to55_A_prefa   ->   c_urb_mig_19to55_A_prefa1982 c_urb_
> mig_19to55_A_prefa1990 ... c_urb_mig_19to55_A_prefa2010
             c_urb_mig_19to55_h_A_prefa   ->   c_urb_mig_19to55_h_A_prefa1982 c_ur
> b_mig_19to55_h_A_prefa1990 ... c_urb_mig_19to55_h_A_prefa2010
                        c_rur_ob__prefa   ->   c_rur_ob__prefa1982 c_rur_ob__prefa
> 1990 ... c_rur_ob__prefa2010
                        c_urb_ob__prefa   ->   c_urb_ob__prefa1982 c_urb_ob__prefa
> 1990 ... c_urb_ob__prefa2010
                 c_rur_ob_19to55__prefa   ->   c_rur_ob_19to55__prefa1982 c_rur_ob
> _19to55__prefa1990 ... c_rur_ob_19to55__prefa2010
                c_rur_ob_19to55_h_prefa   ->   c_rur_ob_19to55_h_prefa1982 c_rur_o
> b_19to55_h_prefa1990 ... c_rur_ob_19to55_h_prefa2010
                 c_urb_ob_19to55__prefa   ->   c_urb_ob_19to55__prefa1982 c_urb_ob
> _19to55__prefa1990 ... c_urb_ob_19to55__prefa2010
                c_urb_ob_19to55_h_prefa   ->   c_urb_ob_19to55_h_prefa1982 c_urb_o
> b_19to55_h_prefa1990 ... c_urb_ob_19to55_h_prefa2010
                      c_rur_ob_A1_prefa   ->   c_rur_ob_A1_prefa1982 c_rur_ob_A1_p
> refa1990 ... c_rur_ob_A1_prefa2010
                      c_urb_ob_A1_prefa   ->   c_urb_ob_A1_prefa1982 c_urb_ob_A1_p
> refa1990 ... c_urb_ob_A1_prefa2010
               c_rur_ob_19to55_A1_prefa   ->   c_rur_ob_19to55_A1_prefa1982 c_rur_
> ob_19to55_A1_prefa1990 ... c_rur_ob_19to55_A1_prefa2010
             c_rur_ob_19to55_h_A1_prefa   ->   c_rur_ob_19to55_h_A1_prefa1982 c_ru
> r_ob_19to55_h_A1_prefa1990 ... c_rur_ob_19to55_h_A1_prefa2010
               c_urb_ob_19to55_A1_prefa   ->   c_urb_ob_19to55_A1_prefa1982 c_urb_
> ob_19to55_A1_prefa1990 ... c_urb_ob_19to55_A1_prefa2010
             c_urb_ob_19to55_h_A1_prefa   ->   c_urb_ob_19to55_h_A1_prefa1982 c_ur
> b_ob_19to55_h_A1_prefa1990 ... c_urb_ob_19to55_h_A1_prefa2010
                      c_rur_ob_A2_prefa   ->   c_rur_ob_A2_prefa1982 c_rur_ob_A2_p
> refa1990 ... c_rur_ob_A2_prefa2010
                      c_urb_ob_A2_prefa   ->   c_urb_ob_A2_prefa1982 c_urb_ob_A2_p
> refa1990 ... c_urb_ob_A2_prefa2010
               c_rur_ob_19to55_A2_prefa   ->   c_rur_ob_19to55_A2_prefa1982 c_rur_
> ob_19to55_A2_prefa1990 ... c_rur_ob_19to55_A2_prefa2010
             c_rur_ob_19to55_h_A2_prefa   ->   c_rur_ob_19to55_h_A2_prefa1982 c_ru
> r_ob_19to55_h_A2_prefa1990 ... c_rur_ob_19to55_h_A2_prefa2010
               c_urb_ob_19to55_A2_prefa   ->   c_urb_ob_19to55_A2_prefa1982 c_urb_
> ob_19to55_A2_prefa1990 ... c_urb_ob_19to55_A2_prefa2010
             c_urb_ob_19to55_h_A2_prefa   ->   c_urb_ob_19to55_h_A2_prefa1982 c_ur
> b_ob_19to55_h_A2_prefa1990 ... c_urb_ob_19to55_h_A2_prefa2010
                        gdp_predc_prefa   ->   gdp_predc_prefa1982 gdp_predc_prefa
> 1990 ... gdp_predc_prefa2010
                        gdp_predf_prefa   ->   gdp_predf_prefa1982 gdp_predf_prefa
> 1990 ... gdp_predf_prefa2010
                  gdp_sect2_predc_prefa   ->   gdp_sect2_predc_prefa1982 gdp_sect2
> _predc_prefa1990 ... gdp_sect2_predc_prefa2010
                  gdp_sect2_predf_prefa   ->   gdp_sect2_predf_prefa1982 gdp_sect2
> _predf_prefa1990 ... gdp_sect2_predf_prefa2010
-----------------------------------------------------------------------------

. *** These are available in the pref data set
. drop a*_prefa1990 *_predc_prefa2010 *_predf_prefa2010

. foreach X of varlist a434_prefa1982-c_urb_ob_19to55_h_A2_prefa2010 {
  2.         qui: sum `X'
  3.          if r(N)==0 {
  4.          drop `X'
  5.         }
  6. }

. 
. sort city05

. save prefa.dta, replace
(note: file prefa.dta not found)
file prefa.dta saved

. 
. 
. ****** 4. 2005 Definition Prefectures Based on Earlier Year Aggregate Data *****
> ****
. 
. use ..\..\data\tabular_data_BJ\generated\pft.dta

. #delimit ;
delimiter now ;
. keep city05 year chg gdp gdp_sector1 gdp_sector2 gdp_sector3 
> tot_pop tot_emp tot_emp_sect2 tot_emp_sect3 total_pop 
> pop gdp_michigan gdp_sector2_mi gdp_sector3_mi totemp gdp_py gdp_sect2 gdp_sect3
>  emp_sect2 emp_sect3
> total_pop givo givo_soe givo_colt fdi area culland cultiland
> num_car bus_trol asset_*
> a101-a452;

. #delimit cr
delimiter now cr
. 
. drop if city05==.
(0 observations deleted)

. keep if year==1990|year==1995|year==2000|year==2005|year==2010
(572 observations deleted)

. 
. foreach X of varlist chg gdp-a452 asset_* {
  2. rename `X' `X'_pref
  3. }

. 
. keep city05 year gdp_pref-a420_pref chg_pref asset_*_pref

. reshape wide gdp_pref-a420_pref chg_pref asset_*_pref, i(city05) j(year)
(note: j = 1990 1995 2000 2005 2010)

Data                               long   ->   wide
-----------------------------------------------------------------------------
Number of obs.                     1430   ->     286
Number of variables                 264   ->    1311
j variable (5 values)              year   ->   (dropped)
xij variables:
                               gdp_pref   ->   gdp_pref1990 gdp_pref1995 ... gdp_p
> ref2010
                       gdp_sector1_pref   ->   gdp_sector1_pref1990 gdp_sector1_pr
> ef1995 ... gdp_sector1_pref2010
                       gdp_sector2_pref   ->   gdp_sector2_pref1990 gdp_sector2_pr
> ef1995 ... gdp_sector2_pref2010
                       gdp_sector3_pref   ->   gdp_sector3_pref1990 gdp_sector3_pr
> ef1995 ... gdp_sector3_pref2010
                           tot_pop_pref   ->   tot_pop_pref1990 tot_pop_pref1995 .
> .. tot_pop_pref2010
                           num_car_pref   ->   num_car_pref1990 num_car_pref1995 .
> .. num_car_pref2010
                           tot_emp_pref   ->   tot_emp_pref1990 tot_emp_pref1995 .
> .. tot_emp_pref2010
                     tot_emp_sect2_pref   ->   tot_emp_sect2_pref1990 tot_emp_sect
> 2_pref1995 ... tot_emp_sect2_pref2010
                     tot_emp_sect3_pref   ->   tot_emp_sect3_pref1990 tot_emp_sect
> 3_pref1995 ... tot_emp_sect3_pref2010
                               pop_pref   ->   pop_pref1990 pop_pref1995 ... pop_p
> ref2010
                      gdp_michigan_pref   ->   gdp_michigan_pref1990 gdp_michigan_
> pref1995 ... gdp_michigan_pref2010
                    gdp_sector2_mi_pref   ->   gdp_sector2_mi_pref1990 gdp_sector2
> _mi_pref1995 ... gdp_sector2_mi_pref2010
                    gdp_sector3_mi_pref   ->   gdp_sector3_mi_pref1990 gdp_sector3
> _mi_pref1995 ... gdp_sector3_mi_pref2010
                              givo_pref   ->   givo_pref1990 givo_pref1995 ... giv
> o_pref2010
                          bus_trol_pref   ->   bus_trol_pref1990 bus_trol_pref1995
>  ... bus_trol_pref2010
                         cultiland_pref   ->   cultiland_pref1990 cultiland_pref19
> 95 ... cultiland_pref2010
                            totemp_pref   ->   totemp_pref1990 totemp_pref1995 ...
>  totemp_pref2010
                            gdp_py_pref   ->   gdp_py_pref1990 gdp_py_pref1995 ...
>  gdp_py_pref2010
                         gdp_sect2_pref   ->   gdp_sect2_pref1990 gdp_sect2_pref19
> 95 ... gdp_sect2_pref2010
                         gdp_sect3_pref   ->   gdp_sect3_pref1990 gdp_sect3_pref19
> 95 ... gdp_sect3_pref2010
                         total_pop_pref   ->   total_pop_pref1990 total_pop_pref19
> 95 ... total_pop_pref2010
                          givo_soe_pref   ->   givo_soe_pref1990 givo_soe_pref1995
>  ... givo_soe_pref2010
                         givo_colt_pref   ->   givo_colt_pref1990 givo_colt_pref19
> 95 ... givo_colt_pref2010
                           culland_pref   ->   culland_pref1990 culland_pref1995 .
> .. culland_pref2010
                              area_pref   ->   area_pref1990 area_pref1995 ... are
> a_pref2010
                         emp_sect2_pref   ->   emp_sect2_pref1990 emp_sect2_pref19
> 95 ... emp_sect2_pref2010
                         emp_sect3_pref   ->   emp_sect3_pref1990 emp_sect3_pref19
> 95 ... emp_sect3_pref2010
                               fdi_pref   ->   fdi_pref1990 fdi_pref1995 ... fdi_p
> ref2010
                              a101_pref   ->   a101_pref1990 a101_pref1995 ... a10
> 1_pref2010
                              a102_pref   ->   a102_pref1990 a102_pref1995 ... a10
> 2_pref2010
                              a103_pref   ->   a103_pref1990 a103_pref1995 ... a10
> 3_pref2010
                              a104_pref   ->   a104_pref1990 a104_pref1995 ... a10
> 4_pref2010
                              a105_pref   ->   a105_pref1990 a105_pref1995 ... a10
> 5_pref2010
                              a106_pref   ->   a106_pref1990 a106_pref1995 ... a10
> 6_pref2010
                              a107_pref   ->   a107_pref1990 a107_pref1995 ... a10
> 7_pref2010
                              a108_pref   ->   a108_pref1990 a108_pref1995 ... a10
> 8_pref2010
                              a109_pref   ->   a109_pref1990 a109_pref1995 ... a10
> 9_pref2010
                              a110_pref   ->   a110_pref1990 a110_pref1995 ... a11
> 0_pref2010
                              a111_pref   ->   a111_pref1990 a111_pref1995 ... a11
> 1_pref2010
                              a112_pref   ->   a112_pref1990 a112_pref1995 ... a11
> 2_pref2010
                              a113_pref   ->   a113_pref1990 a113_pref1995 ... a11
> 3_pref2010
                              a114_pref   ->   a114_pref1990 a114_pref1995 ... a11
> 4_pref2010
                              a115_pref   ->   a115_pref1990 a115_pref1995 ... a11
> 5_pref2010
                              a116_pref   ->   a116_pref1990 a116_pref1995 ... a11
> 6_pref2010
                              a117_pref   ->   a117_pref1990 a117_pref1995 ... a11
> 7_pref2010
                              a118_pref   ->   a118_pref1990 a118_pref1995 ... a11
> 8_pref2010
                              a119_pref   ->   a119_pref1990 a119_pref1995 ... a11
> 9_pref2010
                              a120_pref   ->   a120_pref1990 a120_pref1995 ... a12
> 0_pref2010
                              a121_pref   ->   a121_pref1990 a121_pref1995 ... a12
> 1_pref2010
                              a122_pref   ->   a122_pref1990 a122_pref1995 ... a12
> 2_pref2010
                              a123_pref   ->   a123_pref1990 a123_pref1995 ... a12
> 3_pref2010
                              a124_pref   ->   a124_pref1990 a124_pref1995 ... a12
> 4_pref2010
                              a125_pref   ->   a125_pref1990 a125_pref1995 ... a12
> 5_pref2010
                              a126_pref   ->   a126_pref1990 a126_pref1995 ... a12
> 6_pref2010
                              a127_pref   ->   a127_pref1990 a127_pref1995 ... a12
> 7_pref2010
                              a128_pref   ->   a128_pref1990 a128_pref1995 ... a12
> 8_pref2010
                              a129_pref   ->   a129_pref1990 a129_pref1995 ... a12
> 9_pref2010
                              a130_pref   ->   a130_pref1990 a130_pref1995 ... a13
> 0_pref2010
                              a131_pref   ->   a131_pref1990 a131_pref1995 ... a13
> 1_pref2010
                              a132_pref   ->   a132_pref1990 a132_pref1995 ... a13
> 2_pref2010
                              a133_pref   ->   a133_pref1990 a133_pref1995 ... a13
> 3_pref2010
                              a134_pref   ->   a134_pref1990 a134_pref1995 ... a13
> 4_pref2010
                              a135_pref   ->   a135_pref1990 a135_pref1995 ... a13
> 5_pref2010
                              a136_pref   ->   a136_pref1990 a136_pref1995 ... a13
> 6_pref2010
                              a137_pref   ->   a137_pref1990 a137_pref1995 ... a13
> 7_pref2010
                              a138_pref   ->   a138_pref1990 a138_pref1995 ... a13
> 8_pref2010
                              a139_pref   ->   a139_pref1990 a139_pref1995 ... a13
> 9_pref2010
                              a140_pref   ->   a140_pref1990 a140_pref1995 ... a14
> 0_pref2010
                              a141_pref   ->   a141_pref1990 a141_pref1995 ... a14
> 1_pref2010
                              a142_pref   ->   a142_pref1990 a142_pref1995 ... a14
> 2_pref2010
                              a143_pref   ->   a143_pref1990 a143_pref1995 ... a14
> 3_pref2010
                              a144_pref   ->   a144_pref1990 a144_pref1995 ... a14
> 4_pref2010
                              a145_pref   ->   a145_pref1990 a145_pref1995 ... a14
> 5_pref2010
                              a146_pref   ->   a146_pref1990 a146_pref1995 ... a14
> 6_pref2010
                              a181_pref   ->   a181_pref1990 a181_pref1995 ... a18
> 1_pref2010
                              a182_pref   ->   a182_pref1990 a182_pref1995 ... a18
> 2_pref2010
                              a183_pref   ->   a183_pref1990 a183_pref1995 ... a18
> 3_pref2010
                              a184_pref   ->   a184_pref1990 a184_pref1995 ... a18
> 4_pref2010
                              a185_pref   ->   a185_pref1990 a185_pref1995 ... a18
> 5_pref2010
                              a186_pref   ->   a186_pref1990 a186_pref1995 ... a18
> 6_pref2010
                              a187_pref   ->   a187_pref1990 a187_pref1995 ... a18
> 7_pref2010
                              a188_pref   ->   a188_pref1990 a188_pref1995 ... a18
> 8_pref2010
                              a189_pref   ->   a189_pref1990 a189_pref1995 ... a18
> 9_pref2010
                              a190_pref   ->   a190_pref1990 a190_pref1995 ... a19
> 0_pref2010
                              a191_pref   ->   a191_pref1990 a191_pref1995 ... a19
> 1_pref2010
                              a192_pref   ->   a192_pref1990 a192_pref1995 ... a19
> 2_pref2010
                              a193_pref   ->   a193_pref1990 a193_pref1995 ... a19
> 3_pref2010
                              a194_pref   ->   a194_pref1990 a194_pref1995 ... a19
> 4_pref2010
                              a195_pref   ->   a195_pref1990 a195_pref1995 ... a19
> 5_pref2010
                              a196_pref   ->   a196_pref1990 a196_pref1995 ... a19
> 6_pref2010
                              a197_pref   ->   a197_pref1990 a197_pref1995 ... a19
> 7_pref2010
                              a198_pref   ->   a198_pref1990 a198_pref1995 ... a19
> 8_pref2010
                              a199_pref   ->   a199_pref1990 a199_pref1995 ... a19
> 9_pref2010
                              a200_pref   ->   a200_pref1990 a200_pref1995 ... a20
> 0_pref2010
                              a201_pref   ->   a201_pref1990 a201_pref1995 ... a20
> 1_pref2010
                              a202_pref   ->   a202_pref1990 a202_pref1995 ... a20
> 2_pref2010
                              a203_pref   ->   a203_pref1990 a203_pref1995 ... a20
> 3_pref2010
                              a204_pref   ->   a204_pref1990 a204_pref1995 ... a20
> 4_pref2010
                              a205_pref   ->   a205_pref1990 a205_pref1995 ... a20
> 5_pref2010
                              a206_pref   ->   a206_pref1990 a206_pref1995 ... a20
> 6_pref2010
                              a207_pref   ->   a207_pref1990 a207_pref1995 ... a20
> 7_pref2010
                              a208_pref   ->   a208_pref1990 a208_pref1995 ... a20
> 8_pref2010
                              a209_pref   ->   a209_pref1990 a209_pref1995 ... a20
> 9_pref2010
                              a210_pref   ->   a210_pref1990 a210_pref1995 ... a21
> 0_pref2010
                              a211_pref   ->   a211_pref1990 a211_pref1995 ... a21
> 1_pref2010
                              a212_pref   ->   a212_pref1990 a212_pref1995 ... a21
> 2_pref2010
                              a213_pref   ->   a213_pref1990 a213_pref1995 ... a21
> 3_pref2010
                              a214_pref   ->   a214_pref1990 a214_pref1995 ... a21
> 4_pref2010
                              a215_pref   ->   a215_pref1990 a215_pref1995 ... a21
> 5_pref2010
                              a216_pref   ->   a216_pref1990 a216_pref1995 ... a21
> 6_pref2010
                              a217_pref   ->   a217_pref1990 a217_pref1995 ... a21
> 7_pref2010
                              a218_pref   ->   a218_pref1990 a218_pref1995 ... a21
> 8_pref2010
                              a219_pref   ->   a219_pref1990 a219_pref1995 ... a21
> 9_pref2010
                              a220_pref   ->   a220_pref1990 a220_pref1995 ... a22
> 0_pref2010
                              a221_pref   ->   a221_pref1990 a221_pref1995 ... a22
> 1_pref2010
                              a222_pref   ->   a222_pref1990 a222_pref1995 ... a22
> 2_pref2010
                              a223_pref   ->   a223_pref1990 a223_pref1995 ... a22
> 3_pref2010
                              a224_pref   ->   a224_pref1990 a224_pref1995 ... a22
> 4_pref2010
                              a225_pref   ->   a225_pref1990 a225_pref1995 ... a22
> 5_pref2010
                              a226_pref   ->   a226_pref1990 a226_pref1995 ... a22
> 6_pref2010
                              a227_pref   ->   a227_pref1990 a227_pref1995 ... a22
> 7_pref2010
                              a228_pref   ->   a228_pref1990 a228_pref1995 ... a22
> 8_pref2010
                              a229_pref   ->   a229_pref1990 a229_pref1995 ... a22
> 9_pref2010
                              a230_pref   ->   a230_pref1990 a230_pref1995 ... a23
> 0_pref2010
                              a231_pref   ->   a231_pref1990 a231_pref1995 ... a23
> 1_pref2010
                              a232_pref   ->   a232_pref1990 a232_pref1995 ... a23
> 2_pref2010
                              a233_pref   ->   a233_pref1990 a233_pref1995 ... a23
> 3_pref2010
                              a234_pref   ->   a234_pref1990 a234_pref1995 ... a23
> 4_pref2010
                              a235_pref   ->   a235_pref1990 a235_pref1995 ... a23
> 5_pref2010
                              a236_pref   ->   a236_pref1990 a236_pref1995 ... a23
> 6_pref2010
                              a237_pref   ->   a237_pref1990 a237_pref1995 ... a23
> 7_pref2010
                              a238_pref   ->   a238_pref1990 a238_pref1995 ... a23
> 8_pref2010
                              a239_pref   ->   a239_pref1990 a239_pref1995 ... a23
> 9_pref2010
                              a240_pref   ->   a240_pref1990 a240_pref1995 ... a24
> 0_pref2010
                              a241_pref   ->   a241_pref1990 a241_pref1995 ... a24
> 1_pref2010
                              a242_pref   ->   a242_pref1990 a242_pref1995 ... a24
> 2_pref2010
                              a243_pref   ->   a243_pref1990 a243_pref1995 ... a24
> 3_pref2010
                              a244_pref   ->   a244_pref1990 a244_pref1995 ... a24
> 4_pref2010
                              a245_pref   ->   a245_pref1990 a245_pref1995 ... a24
> 5_pref2010
                              a246_pref   ->   a246_pref1990 a246_pref1995 ... a24
> 6_pref2010
                              a261_pref   ->   a261_pref1990 a261_pref1995 ... a26
> 1_pref2010
                              a262_pref   ->   a262_pref1990 a262_pref1995 ... a26
> 2_pref2010
                              a263_pref   ->   a263_pref1990 a263_pref1995 ... a26
> 3_pref2010
                              a264_pref   ->   a264_pref1990 a264_pref1995 ... a26
> 4_pref2010
                              a265_pref   ->   a265_pref1990 a265_pref1995 ... a26
> 5_pref2010
                              a266_pref   ->   a266_pref1990 a266_pref1995 ... a26
> 6_pref2010
                              a267_pref   ->   a267_pref1990 a267_pref1995 ... a26
> 7_pref2010
                              a268_pref   ->   a268_pref1990 a268_pref1995 ... a26
> 8_pref2010
                              a269_pref   ->   a269_pref1990 a269_pref1995 ... a26
> 9_pref2010
                              a270_pref   ->   a270_pref1990 a270_pref1995 ... a27
> 0_pref2010
                              a271_pref   ->   a271_pref1990 a271_pref1995 ... a27
> 1_pref2010
                              a272_pref   ->   a272_pref1990 a272_pref1995 ... a27
> 2_pref2010
                              a273_pref   ->   a273_pref1990 a273_pref1995 ... a27
> 3_pref2010
                              a274_pref   ->   a274_pref1990 a274_pref1995 ... a27
> 4_pref2010
                              a275_pref   ->   a275_pref1990 a275_pref1995 ... a27
> 5_pref2010
                              a276_pref   ->   a276_pref1990 a276_pref1995 ... a27
> 6_pref2010
                              a277_pref   ->   a277_pref1990 a277_pref1995 ... a27
> 7_pref2010
                              a278_pref   ->   a278_pref1990 a278_pref1995 ... a27
> 8_pref2010
                              a279_pref   ->   a279_pref1990 a279_pref1995 ... a27
> 9_pref2010
                              a280_pref   ->   a280_pref1990 a280_pref1995 ... a28
> 0_pref2010
                              a281_pref   ->   a281_pref1990 a281_pref1995 ... a28
> 1_pref2010
                              a282_pref   ->   a282_pref1990 a282_pref1995 ... a28
> 2_pref2010
                              a283_pref   ->   a283_pref1990 a283_pref1995 ... a28
> 3_pref2010
                              a284_pref   ->   a284_pref1990 a284_pref1995 ... a28
> 4_pref2010
                              a291_pref   ->   a291_pref1990 a291_pref1995 ... a29
> 1_pref2010
                              a292_pref   ->   a292_pref1990 a292_pref1995 ... a29
> 2_pref2010
                              a293_pref   ->   a293_pref1990 a293_pref1995 ... a29
> 3_pref2010
                              a294_pref   ->   a294_pref1990 a294_pref1995 ... a29
> 4_pref2010
                              a295_pref   ->   a295_pref1990 a295_pref1995 ... a29
> 5_pref2010
                              a296_pref   ->   a296_pref1990 a296_pref1995 ... a29
> 6_pref2010
                              a301_pref   ->   a301_pref1990 a301_pref1995 ... a30
> 1_pref2010
                              a302_pref   ->   a302_pref1990 a302_pref1995 ... a30
> 2_pref2010
                              a303_pref   ->   a303_pref1990 a303_pref1995 ... a30
> 3_pref2010
                              a304_pref   ->   a304_pref1990 a304_pref1995 ... a30
> 4_pref2010
                              a305_pref   ->   a305_pref1990 a305_pref1995 ... a30
> 5_pref2010
                              a306_pref   ->   a306_pref1990 a306_pref1995 ... a30
> 6_pref2010
                              a307_pref   ->   a307_pref1990 a307_pref1995 ... a30
> 7_pref2010
                              a308_pref   ->   a308_pref1990 a308_pref1995 ... a30
> 8_pref2010
                              a309_pref   ->   a309_pref1990 a309_pref1995 ... a30
> 9_pref2010
                              a310_pref   ->   a310_pref1990 a310_pref1995 ... a31
> 0_pref2010
                              a311_pref   ->   a311_pref1990 a311_pref1995 ... a31
> 1_pref2010
                              a312_pref   ->   a312_pref1990 a312_pref1995 ... a31
> 2_pref2010
                              a313_pref   ->   a313_pref1990 a313_pref1995 ... a31
> 3_pref2010
                              a314_pref   ->   a314_pref1990 a314_pref1995 ... a31
> 4_pref2010
                              a315_pref   ->   a315_pref1990 a315_pref1995 ... a31
> 5_pref2010
                              a321_pref   ->   a321_pref1990 a321_pref1995 ... a32
> 1_pref2010
                              a322_pref   ->   a322_pref1990 a322_pref1995 ... a32
> 2_pref2010
                              a323_pref   ->   a323_pref1990 a323_pref1995 ... a32
> 3_pref2010
                              a324_pref   ->   a324_pref1990 a324_pref1995 ... a32
> 4_pref2010
                              a325_pref   ->   a325_pref1990 a325_pref1995 ... a32
> 5_pref2010
                              a326_pref   ->   a326_pref1990 a326_pref1995 ... a32
> 6_pref2010
                              a327_pref   ->   a327_pref1990 a327_pref1995 ... a32
> 7_pref2010
                              a328_pref   ->   a328_pref1990 a328_pref1995 ... a32
> 8_pref2010
                              a329_pref   ->   a329_pref1990 a329_pref1995 ... a32
> 9_pref2010
                              a330_pref   ->   a330_pref1990 a330_pref1995 ... a33
> 0_pref2010
                              a331_pref   ->   a331_pref1990 a331_pref1995 ... a33
> 1_pref2010
                              a332_pref   ->   a332_pref1990 a332_pref1995 ... a33
> 2_pref2010
                              a341_pref   ->   a341_pref1990 a341_pref1995 ... a34
> 1_pref2010
                              a342_pref   ->   a342_pref1990 a342_pref1995 ... a34
> 2_pref2010
                              a343_pref   ->   a343_pref1990 a343_pref1995 ... a34
> 3_pref2010
                              a344_pref   ->   a344_pref1990 a344_pref1995 ... a34
> 4_pref2010
                              a345_pref   ->   a345_pref1990 a345_pref1995 ... a34
> 5_pref2010
                              a346_pref   ->   a346_pref1990 a346_pref1995 ... a34
> 6_pref2010
                              a347_pref   ->   a347_pref1990 a347_pref1995 ... a34
> 7_pref2010
                              a348_pref   ->   a348_pref1990 a348_pref1995 ... a34
> 8_pref2010
                              a349_pref   ->   a349_pref1990 a349_pref1995 ... a34
> 9_pref2010
                              a350_pref   ->   a350_pref1990 a350_pref1995 ... a35
> 0_pref2010
                              a351_pref   ->   a351_pref1990 a351_pref1995 ... a35
> 1_pref2010
                              a352_pref   ->   a352_pref1990 a352_pref1995 ... a35
> 2_pref2010
                              a361_pref   ->   a361_pref1990 a361_pref1995 ... a36
> 1_pref2010
                              a362_pref   ->   a362_pref1990 a362_pref1995 ... a36
> 2_pref2010
                              a363_pref   ->   a363_pref1990 a363_pref1995 ... a36
> 3_pref2010
                              a364_pref   ->   a364_pref1990 a364_pref1995 ... a36
> 4_pref2010
                              a365_pref   ->   a365_pref1990 a365_pref1995 ... a36
> 5_pref2010
                              a366_pref   ->   a366_pref1990 a366_pref1995 ... a36
> 6_pref2010
                              a367_pref   ->   a367_pref1990 a367_pref1995 ... a36
> 7_pref2010
                              a368_pref   ->   a368_pref1990 a368_pref1995 ... a36
> 8_pref2010
                              a369_pref   ->   a369_pref1990 a369_pref1995 ... a36
> 9_pref2010
                              a370_pref   ->   a370_pref1990 a370_pref1995 ... a37
> 0_pref2010
                              a381_pref   ->   a381_pref1990 a381_pref1995 ... a38
> 1_pref2010
                              a382_pref   ->   a382_pref1990 a382_pref1995 ... a38
> 2_pref2010
                              a383_pref   ->   a383_pref1990 a383_pref1995 ... a38
> 3_pref2010
                              a384_pref   ->   a384_pref1990 a384_pref1995 ... a38
> 4_pref2010
                              a385_pref   ->   a385_pref1990 a385_pref1995 ... a38
> 5_pref2010
                              a386_pref   ->   a386_pref1990 a386_pref1995 ... a38
> 6_pref2010
                              a387_pref   ->   a387_pref1990 a387_pref1995 ... a38
> 7_pref2010
                              a388_pref   ->   a388_pref1990 a388_pref1995 ... a38
> 8_pref2010
                              a389_pref   ->   a389_pref1990 a389_pref1995 ... a38
> 9_pref2010
                              a390_pref   ->   a390_pref1990 a390_pref1995 ... a39
> 0_pref2010
                              a391_pref   ->   a391_pref1990 a391_pref1995 ... a39
> 1_pref2010
                              a392_pref   ->   a392_pref1990 a392_pref1995 ... a39
> 2_pref2010
                              a393_pref   ->   a393_pref1990 a393_pref1995 ... a39
> 3_pref2010
                              a394_pref   ->   a394_pref1990 a394_pref1995 ... a39
> 4_pref2010
                              a395_pref   ->   a395_pref1990 a395_pref1995 ... a39
> 5_pref2010
                              a396_pref   ->   a396_pref1990 a396_pref1995 ... a39
> 6_pref2010
                              a397_pref   ->   a397_pref1990 a397_pref1995 ... a39
> 7_pref2010
                              a398_pref   ->   a398_pref1990 a398_pref1995 ... a39
> 8_pref2010
                              a399_pref   ->   a399_pref1990 a399_pref1995 ... a39
> 9_pref2010
                              a400_pref   ->   a400_pref1990 a400_pref1995 ... a40
> 0_pref2010
                              a401_pref   ->   a401_pref1990 a401_pref1995 ... a40
> 1_pref2010
                              a402_pref   ->   a402_pref1990 a402_pref1995 ... a40
> 2_pref2010
                              a403_pref   ->   a403_pref1990 a403_pref1995 ... a40
> 3_pref2010
                              a404_pref   ->   a404_pref1990 a404_pref1995 ... a40
> 4_pref2010
                              a405_pref   ->   a405_pref1990 a405_pref1995 ... a40
> 5_pref2010
                              a406_pref   ->   a406_pref1990 a406_pref1995 ... a40
> 6_pref2010
                              a407_pref   ->   a407_pref1990 a407_pref1995 ... a40
> 7_pref2010
                              a408_pref   ->   a408_pref1990 a408_pref1995 ... a40
> 8_pref2010
                              a409_pref   ->   a409_pref1990 a409_pref1995 ... a40
> 9_pref2010
                              a410_pref   ->   a410_pref1990 a410_pref1995 ... a41
> 0_pref2010
                              a411_pref   ->   a411_pref1990 a411_pref1995 ... a41
> 1_pref2010
                              a412_pref   ->   a412_pref1990 a412_pref1995 ... a41
> 2_pref2010
                              a413_pref   ->   a413_pref1990 a413_pref1995 ... a41
> 3_pref2010
                              a414_pref   ->   a414_pref1990 a414_pref1995 ... a41
> 4_pref2010
                              a415_pref   ->   a415_pref1990 a415_pref1995 ... a41
> 5_pref2010
                              a416_pref   ->   a416_pref1990 a416_pref1995 ... a41
> 6_pref2010
                              a417_pref   ->   a417_pref1990 a417_pref1995 ... a41
> 7_pref2010
                              a418_pref   ->   a418_pref1990 a418_pref1995 ... a41
> 8_pref2010
                              a419_pref   ->   a419_pref1990 a419_pref1995 ... a41
> 9_pref2010
                              a420_pref   ->   a420_pref1990 a420_pref1995 ... a42
> 0_pref2010
                               chg_pref   ->   chg_pref1990 chg_pref1995 ... chg_p
> ref2010
                        asset_g_qz_pref   ->   asset_g_qz_pref1990 asset_g_qz_pref
> 1995 ... asset_g_qz_pref2010
                        asset_n_qz_pref   ->   asset_n_qz_pref1990 asset_n_qz_pref
> 1995 ... asset_n_qz_pref2010
-----------------------------------------------------------------------------

. 
. foreach X of varlist gdp_pref1990-chg_pref2010 {
  2.         qui: sum `X'
  3.          if r(N)==0 {
  4.          drop `X'
  5.         }
  6. }

. sort city05

. save pref.dta, replace
(note: file pref.dta not found)
file pref.dta saved

. 
. 
. **************** 5. Prefectures by adding prefec remainders to city propers ****
> ****************
. 
. use cpt.dta

. sort city05 year

. merge city05 year using ..\..\data\tabular_data_BJ\generated\agg_noncpt.dta
(note: you are using old merge syntax; see [D] merge for new syntax)
(note: variable city05 was float, now double to accommodate using data's values)
(note: variable totemp was float, now double to accommodate using data's values)
(note: variable gdp_py was float, now double to accommodate using data's values)
(note: variable gdp_sect2 was float, now double to accommodate using data's
       values)
(note: variable gdp_sect3 was float, now double to accommodate using data's
       values)
(note: variable total_pop was float, now double to accommodate using data's
       values)
(note: variable kmpr was int, now double to accommodate using data's values)
(note: variable apr was int, now double to accommodate using data's values)
(note: variable avgsalary was float, now double to accommodate using data's
       values)
(note: variable givo_py was float, now double to accommodate using data's
       values)
(note: variable givo_soe was float, now double to accommodate using data's
       values)
(note: variable givo_colt was float, now double to accommodate using data's
       values)
(note: variable area was int, now double to accommodate using data's values)
(note: variable fixinvest was float, now double to accommodate using data's
       values)
(note: variable fdi_py was long, now double to accommodate using data's values)

. drop if city05==.
(0 observations deleted)

. *** sometimes no city, sometimes no remainder
. tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         36        1.80        1.80
          2 |        489       24.43       26.22
          3 |      1,477       73.78      100.00
------------+-----------------------------------
      Total |      2,002      100.00

. #delimit ;
delimiter now ;
. keep city05 year _merge
> gdp gdp_sector1 gdp_sector2 gdp_sector3 tot_pop 
> pop gdp_michigan
> gdp_predf gdp_predc gdp_sect2_predf gdp_sect2_predc
> a101-a452
> a_gdp a_gdp_sector1 a_gdp_sector2 a_gdp_sector3 a_tot_pop 
> a_pop a_gdp_michigan
> a_gdp_predf a_gdp_predc a_gdp_sect2_predf a_gdp_sect2_predc
> a_a101-a_a452;

. foreach X of varlist gdp gdp_sector1 gdp_sector2 gdp_sector3 tot_pop pop 
> gdp_michigan gdp_predf gdp_predc gdp_sect2_predf gdp_sect2_predc a1* a2* a3* a4*
>  {;
  2. replace a_`X' = `X'+a_`X' if _merge==3;
  3. rename a_`X' `X'_prefb;
  4. drop `X';
  5. };
(107 real changes made, 8 to missing)
(77 real changes made, 9 to missing)
(89 real changes made, 11 to missing)
(88 real changes made, 44 to missing)
(167 real changes made, 5 to missing)
(1,021 real changes made, 5 to missing)
(1,021 real changes made, 2 to missing)
(352 real changes made, 185 to missing)
(352 real changes made, 185 to missing)
(352 real changes made, 185 to missing)
(352 real changes made, 185 to missing)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(107 real changes made)
(107 real changes made)
(107 real changes made)
(105 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(162 real changes made)
(157 real changes made)
(162 real changes made)
(153 real changes made)
(108 real changes made)
(148 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(155 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(165 real changes made)
(165 real changes made)
(150 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(168 real changes made)
(168 real changes made)
(168 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(155 real changes made)
(152 real changes made)
(131 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(169 real changes made)
(154 real changes made)

. #delimit cr
delimiter now cr
. drop _merge

. drop a_a*

. drop if year==1982
(286 observations deleted)

. 
. reshape wide gdp_prefb-gdp_sect2_predc_prefb, i(city05) j(year)
(note: j = 1990 1995 2000 2005 2008 2010)

Data                               long   ->   wide
-----------------------------------------------------------------------------
Number of obs.                     1716   ->     286
Number of variables                 242   ->    1441
j variable (6 values)              year   ->   (dropped)
xij variables:
                              gdp_prefb   ->   gdp_prefb1990 gdp_prefb1995 ... gdp
> _prefb2010
                      gdp_sector1_prefb   ->   gdp_sector1_prefb1990 gdp_sector1_p
> refb1995 ... gdp_sector1_prefb2010
                      gdp_sector2_prefb   ->   gdp_sector2_prefb1990 gdp_sector2_p
> refb1995 ... gdp_sector2_prefb2010
                      gdp_sector3_prefb   ->   gdp_sector3_prefb1990 gdp_sector3_p
> refb1995 ... gdp_sector3_prefb2010
                          tot_pop_prefb   ->   tot_pop_prefb1990 tot_pop_prefb1995
>  ... tot_pop_prefb2010
                              pop_prefb   ->   pop_prefb1990 pop_prefb1995 ... pop
> _prefb2010
                     gdp_michigan_prefb   ->   gdp_michigan_prefb1990 gdp_michigan
> _prefb1995 ... gdp_michigan_prefb2010
                             a101_prefb   ->   a101_prefb1990 a101_prefb1995 ... a
> 101_prefb2010
                             a105_prefb   ->   a105_prefb1990 a105_prefb1995 ... a
> 105_prefb2010
                             a106_prefb   ->   a106_prefb1990 a106_prefb1995 ... a
> 106_prefb2010
                             a107_prefb   ->   a107_prefb1990 a107_prefb1995 ... a
> 107_prefb2010
                             a108_prefb   ->   a108_prefb1990 a108_prefb1995 ... a
> 108_prefb2010
                             a109_prefb   ->   a109_prefb1990 a109_prefb1995 ... a
> 109_prefb2010
                             a110_prefb   ->   a110_prefb1990 a110_prefb1995 ... a
> 110_prefb2010
                             a111_prefb   ->   a111_prefb1990 a111_prefb1995 ... a
> 111_prefb2010
                             a112_prefb   ->   a112_prefb1990 a112_prefb1995 ... a
> 112_prefb2010
                             a113_prefb   ->   a113_prefb1990 a113_prefb1995 ... a
> 113_prefb2010
                             a114_prefb   ->   a114_prefb1990 a114_prefb1995 ... a
> 114_prefb2010
                             a115_prefb   ->   a115_prefb1990 a115_prefb1995 ... a
> 115_prefb2010
                             a116_prefb   ->   a116_prefb1990 a116_prefb1995 ... a
> 116_prefb2010
                             a118_prefb   ->   a118_prefb1990 a118_prefb1995 ... a
> 118_prefb2010
                             a119_prefb   ->   a119_prefb1990 a119_prefb1995 ... a
> 119_prefb2010
                             a121_prefb   ->   a121_prefb1990 a121_prefb1995 ... a
> 121_prefb2010
                             a122_prefb   ->   a122_prefb1990 a122_prefb1995 ... a
> 122_prefb2010
                             a123_prefb   ->   a123_prefb1990 a123_prefb1995 ... a
> 123_prefb2010
                             a124_prefb   ->   a124_prefb1990 a124_prefb1995 ... a
> 124_prefb2010
                             a125_prefb   ->   a125_prefb1990 a125_prefb1995 ... a
> 125_prefb2010
                             a126_prefb   ->   a126_prefb1990 a126_prefb1995 ... a
> 126_prefb2010
                             a127_prefb   ->   a127_prefb1990 a127_prefb1995 ... a
> 127_prefb2010
                             a128_prefb   ->   a128_prefb1990 a128_prefb1995 ... a
> 128_prefb2010
                             a129_prefb   ->   a129_prefb1990 a129_prefb1995 ... a
> 129_prefb2010
                             a130_prefb   ->   a130_prefb1990 a130_prefb1995 ... a
> 130_prefb2010
                             a131_prefb   ->   a131_prefb1990 a131_prefb1995 ... a
> 131_prefb2010
                             a132_prefb   ->   a132_prefb1990 a132_prefb1995 ... a
> 132_prefb2010
                             a133_prefb   ->   a133_prefb1990 a133_prefb1995 ... a
> 133_prefb2010
                             a134_prefb   ->   a134_prefb1990 a134_prefb1995 ... a
> 134_prefb2010
                             a135_prefb   ->   a135_prefb1990 a135_prefb1995 ... a
> 135_prefb2010
                             a136_prefb   ->   a136_prefb1990 a136_prefb1995 ... a
> 136_prefb2010
                             a137_prefb   ->   a137_prefb1990 a137_prefb1995 ... a
> 137_prefb2010
                             a138_prefb   ->   a138_prefb1990 a138_prefb1995 ... a
> 138_prefb2010
                             a139_prefb   ->   a139_prefb1990 a139_prefb1995 ... a
> 139_prefb2010
                             a140_prefb   ->   a140_prefb1990 a140_prefb1995 ... a
> 140_prefb2010
                             a141_prefb   ->   a141_prefb1990 a141_prefb1995 ... a
> 141_prefb2010
                             a142_prefb   ->   a142_prefb1990 a142_prefb1995 ... a
> 142_prefb2010
                             a143_prefb   ->   a143_prefb1990 a143_prefb1995 ... a
> 143_prefb2010
                             a144_prefb   ->   a144_prefb1990 a144_prefb1995 ... a
> 144_prefb2010
                             a145_prefb   ->   a145_prefb1990 a145_prefb1995 ... a
> 145_prefb2010
                             a146_prefb   ->   a146_prefb1990 a146_prefb1995 ... a
> 146_prefb2010
                             a181_prefb   ->   a181_prefb1990 a181_prefb1995 ... a
> 181_prefb2010
                             a182_prefb   ->   a182_prefb1990 a182_prefb1995 ... a
> 182_prefb2010
                             a183_prefb   ->   a183_prefb1990 a183_prefb1995 ... a
> 183_prefb2010
                             a196_prefb   ->   a196_prefb1990 a196_prefb1995 ... a
> 196_prefb2010
                             a197_prefb   ->   a197_prefb1990 a197_prefb1995 ... a
> 197_prefb2010
                             a198_prefb   ->   a198_prefb1990 a198_prefb1995 ... a
> 198_prefb2010
                             a199_prefb   ->   a199_prefb1990 a199_prefb1995 ... a
> 199_prefb2010
                             a200_prefb   ->   a200_prefb1990 a200_prefb1995 ... a
> 200_prefb2010
                             a201_prefb   ->   a201_prefb1990 a201_prefb1995 ... a
> 201_prefb2010
                             a202_prefb   ->   a202_prefb1990 a202_prefb1995 ... a
> 202_prefb2010
                             a203_prefb   ->   a203_prefb1990 a203_prefb1995 ... a
> 203_prefb2010
                             a204_prefb   ->   a204_prefb1990 a204_prefb1995 ... a
> 204_prefb2010
                             a205_prefb   ->   a205_prefb1990 a205_prefb1995 ... a
> 205_prefb2010
                             a206_prefb   ->   a206_prefb1990 a206_prefb1995 ... a
> 206_prefb2010
                             a207_prefb   ->   a207_prefb1990 a207_prefb1995 ... a
> 207_prefb2010
                             a208_prefb   ->   a208_prefb1990 a208_prefb1995 ... a
> 208_prefb2010
                             a209_prefb   ->   a209_prefb1990 a209_prefb1995 ... a
> 209_prefb2010
                             a210_prefb   ->   a210_prefb1990 a210_prefb1995 ... a
> 210_prefb2010
                             a211_prefb   ->   a211_prefb1990 a211_prefb1995 ... a
> 211_prefb2010
                             a212_prefb   ->   a212_prefb1990 a212_prefb1995 ... a
> 212_prefb2010
                             a213_prefb   ->   a213_prefb1990 a213_prefb1995 ... a
> 213_prefb2010
                             a214_prefb   ->   a214_prefb1990 a214_prefb1995 ... a
> 214_prefb2010
                             a215_prefb   ->   a215_prefb1990 a215_prefb1995 ... a
> 215_prefb2010
                             a216_prefb   ->   a216_prefb1990 a216_prefb1995 ... a
> 216_prefb2010
                             a217_prefb   ->   a217_prefb1990 a217_prefb1995 ... a
> 217_prefb2010
                             a218_prefb   ->   a218_prefb1990 a218_prefb1995 ... a
> 218_prefb2010
                             a219_prefb   ->   a219_prefb1990 a219_prefb1995 ... a
> 219_prefb2010
                             a220_prefb   ->   a220_prefb1990 a220_prefb1995 ... a
> 220_prefb2010
                             a221_prefb   ->   a221_prefb1990 a221_prefb1995 ... a
> 221_prefb2010
                             a222_prefb   ->   a222_prefb1990 a222_prefb1995 ... a
> 222_prefb2010
                             a223_prefb   ->   a223_prefb1990 a223_prefb1995 ... a
> 223_prefb2010
                             a224_prefb   ->   a224_prefb1990 a224_prefb1995 ... a
> 224_prefb2010
                             a225_prefb   ->   a225_prefb1990 a225_prefb1995 ... a
> 225_prefb2010
                             a226_prefb   ->   a226_prefb1990 a226_prefb1995 ... a
> 226_prefb2010
                             a227_prefb   ->   a227_prefb1990 a227_prefb1995 ... a
> 227_prefb2010
                             a228_prefb   ->   a228_prefb1990 a228_prefb1995 ... a
> 228_prefb2010
                             a229_prefb   ->   a229_prefb1990 a229_prefb1995 ... a
> 229_prefb2010
                             a230_prefb   ->   a230_prefb1990 a230_prefb1995 ... a
> 230_prefb2010
                             a231_prefb   ->   a231_prefb1990 a231_prefb1995 ... a
> 231_prefb2010
                             a232_prefb   ->   a232_prefb1990 a232_prefb1995 ... a
> 232_prefb2010
                             a233_prefb   ->   a233_prefb1990 a233_prefb1995 ... a
> 233_prefb2010
                             a234_prefb   ->   a234_prefb1990 a234_prefb1995 ... a
> 234_prefb2010
                             a235_prefb   ->   a235_prefb1990 a235_prefb1995 ... a
> 235_prefb2010
                             a236_prefb   ->   a236_prefb1990 a236_prefb1995 ... a
> 236_prefb2010
                             a237_prefb   ->   a237_prefb1990 a237_prefb1995 ... a
> 237_prefb2010
                             a238_prefb   ->   a238_prefb1990 a238_prefb1995 ... a
> 238_prefb2010
                             a239_prefb   ->   a239_prefb1990 a239_prefb1995 ... a
> 239_prefb2010
                             a240_prefb   ->   a240_prefb1990 a240_prefb1995 ... a
> 240_prefb2010
                             a241_prefb   ->   a241_prefb1990 a241_prefb1995 ... a
> 241_prefb2010
                             a242_prefb   ->   a242_prefb1990 a242_prefb1995 ... a
> 242_prefb2010
                             a243_prefb   ->   a243_prefb1990 a243_prefb1995 ... a
> 243_prefb2010
                             a244_prefb   ->   a244_prefb1990 a244_prefb1995 ... a
> 244_prefb2010
                             a245_prefb   ->   a245_prefb1990 a245_prefb1995 ... a
> 245_prefb2010
                             a246_prefb   ->   a246_prefb1990 a246_prefb1995 ... a
> 246_prefb2010
                             a261_prefb   ->   a261_prefb1990 a261_prefb1995 ... a
> 261_prefb2010
                             a262_prefb   ->   a262_prefb1990 a262_prefb1995 ... a
> 262_prefb2010
                             a263_prefb   ->   a263_prefb1990 a263_prefb1995 ... a
> 263_prefb2010
                             a264_prefb   ->   a264_prefb1990 a264_prefb1995 ... a
> 264_prefb2010
                             a267_prefb   ->   a267_prefb1990 a267_prefb1995 ... a
> 267_prefb2010
                             a270_prefb   ->   a270_prefb1990 a270_prefb1995 ... a
> 270_prefb2010
                             a271_prefb   ->   a271_prefb1990 a271_prefb1995 ... a
> 271_prefb2010
                             a272_prefb   ->   a272_prefb1990 a272_prefb1995 ... a
> 272_prefb2010
                             a273_prefb   ->   a273_prefb1990 a273_prefb1995 ... a
> 273_prefb2010
                             a274_prefb   ->   a274_prefb1990 a274_prefb1995 ... a
> 274_prefb2010
                             a275_prefb   ->   a275_prefb1990 a275_prefb1995 ... a
> 275_prefb2010
                             a276_prefb   ->   a276_prefb1990 a276_prefb1995 ... a
> 276_prefb2010
                             a279_prefb   ->   a279_prefb1990 a279_prefb1995 ... a
> 279_prefb2010
                             a282_prefb   ->   a282_prefb1990 a282_prefb1995 ... a
> 282_prefb2010
                             a283_prefb   ->   a283_prefb1990 a283_prefb1995 ... a
> 283_prefb2010
                             a284_prefb   ->   a284_prefb1990 a284_prefb1995 ... a
> 284_prefb2010
                             a291_prefb   ->   a291_prefb1990 a291_prefb1995 ... a
> 291_prefb2010
                             a292_prefb   ->   a292_prefb1990 a292_prefb1995 ... a
> 292_prefb2010
                             a293_prefb   ->   a293_prefb1990 a293_prefb1995 ... a
> 293_prefb2010
                             a294_prefb   ->   a294_prefb1990 a294_prefb1995 ... a
> 294_prefb2010
                             a295_prefb   ->   a295_prefb1990 a295_prefb1995 ... a
> 295_prefb2010
                             a296_prefb   ->   a296_prefb1990 a296_prefb1995 ... a
> 296_prefb2010
                             a301_prefb   ->   a301_prefb1990 a301_prefb1995 ... a
> 301_prefb2010
                             a302_prefb   ->   a302_prefb1990 a302_prefb1995 ... a
> 302_prefb2010
                             a303_prefb   ->   a303_prefb1990 a303_prefb1995 ... a
> 303_prefb2010
                             a304_prefb   ->   a304_prefb1990 a304_prefb1995 ... a
> 304_prefb2010
                             a305_prefb   ->   a305_prefb1990 a305_prefb1995 ... a
> 305_prefb2010
                             a306_prefb   ->   a306_prefb1990 a306_prefb1995 ... a
> 306_prefb2010
                             a307_prefb   ->   a307_prefb1990 a307_prefb1995 ... a
> 307_prefb2010
                             a308_prefb   ->   a308_prefb1990 a308_prefb1995 ... a
> 308_prefb2010
                             a309_prefb   ->   a309_prefb1990 a309_prefb1995 ... a
> 309_prefb2010
                             a310_prefb   ->   a310_prefb1990 a310_prefb1995 ... a
> 310_prefb2010
                             a311_prefb   ->   a311_prefb1990 a311_prefb1995 ... a
> 311_prefb2010
                             a312_prefb   ->   a312_prefb1990 a312_prefb1995 ... a
> 312_prefb2010
                             a313_prefb   ->   a313_prefb1990 a313_prefb1995 ... a
> 313_prefb2010
                             a314_prefb   ->   a314_prefb1990 a314_prefb1995 ... a
> 314_prefb2010
                             a315_prefb   ->   a315_prefb1990 a315_prefb1995 ... a
> 315_prefb2010
                             a321_prefb   ->   a321_prefb1990 a321_prefb1995 ... a
> 321_prefb2010
                             a322_prefb   ->   a322_prefb1990 a322_prefb1995 ... a
> 322_prefb2010
                             a323_prefb   ->   a323_prefb1990 a323_prefb1995 ... a
> 323_prefb2010
                             a324_prefb   ->   a324_prefb1990 a324_prefb1995 ... a
> 324_prefb2010
                             a325_prefb   ->   a325_prefb1990 a325_prefb1995 ... a
> 325_prefb2010
                             a326_prefb   ->   a326_prefb1990 a326_prefb1995 ... a
> 326_prefb2010
                             a327_prefb   ->   a327_prefb1990 a327_prefb1995 ... a
> 327_prefb2010
                             a328_prefb   ->   a328_prefb1990 a328_prefb1995 ... a
> 328_prefb2010
                             a329_prefb   ->   a329_prefb1990 a329_prefb1995 ... a
> 329_prefb2010
                             a330_prefb   ->   a330_prefb1990 a330_prefb1995 ... a
> 330_prefb2010
                             a331_prefb   ->   a331_prefb1990 a331_prefb1995 ... a
> 331_prefb2010
                             a332_prefb   ->   a332_prefb1990 a332_prefb1995 ... a
> 332_prefb2010
                             a341_prefb   ->   a341_prefb1990 a341_prefb1995 ... a
> 341_prefb2010
                             a342_prefb   ->   a342_prefb1990 a342_prefb1995 ... a
> 342_prefb2010
                             a343_prefb   ->   a343_prefb1990 a343_prefb1995 ... a
> 343_prefb2010
                             a344_prefb   ->   a344_prefb1990 a344_prefb1995 ... a
> 344_prefb2010
                             a345_prefb   ->   a345_prefb1990 a345_prefb1995 ... a
> 345_prefb2010
                             a346_prefb   ->   a346_prefb1990 a346_prefb1995 ... a
> 346_prefb2010
                             a347_prefb   ->   a347_prefb1990 a347_prefb1995 ... a
> 347_prefb2010
                             a348_prefb   ->   a348_prefb1990 a348_prefb1995 ... a
> 348_prefb2010
                             a349_prefb   ->   a349_prefb1990 a349_prefb1995 ... a
> 349_prefb2010
                             a350_prefb   ->   a350_prefb1990 a350_prefb1995 ... a
> 350_prefb2010
                             a351_prefb   ->   a351_prefb1990 a351_prefb1995 ... a
> 351_prefb2010
                             a352_prefb   ->   a352_prefb1990 a352_prefb1995 ... a
> 352_prefb2010
                             a361_prefb   ->   a361_prefb1990 a361_prefb1995 ... a
> 361_prefb2010
                             a362_prefb   ->   a362_prefb1990 a362_prefb1995 ... a
> 362_prefb2010
                             a363_prefb   ->   a363_prefb1990 a363_prefb1995 ... a
> 363_prefb2010
                             a364_prefb   ->   a364_prefb1990 a364_prefb1995 ... a
> 364_prefb2010
                             a365_prefb   ->   a365_prefb1990 a365_prefb1995 ... a
> 365_prefb2010
                             a366_prefb   ->   a366_prefb1990 a366_prefb1995 ... a
> 366_prefb2010
                             a367_prefb   ->   a367_prefb1990 a367_prefb1995 ... a
> 367_prefb2010
                             a368_prefb   ->   a368_prefb1990 a368_prefb1995 ... a
> 368_prefb2010
                             a369_prefb   ->   a369_prefb1990 a369_prefb1995 ... a
> 369_prefb2010
                             a370_prefb   ->   a370_prefb1990 a370_prefb1995 ... a
> 370_prefb2010
                             a382_prefb   ->   a382_prefb1990 a382_prefb1995 ... a
> 382_prefb2010
                             a383_prefb   ->   a383_prefb1990 a383_prefb1995 ... a
> 383_prefb2010
                             a384_prefb   ->   a384_prefb1990 a384_prefb1995 ... a
> 384_prefb2010
                             a385_prefb   ->   a385_prefb1990 a385_prefb1995 ... a
> 385_prefb2010
                             a386_prefb   ->   a386_prefb1990 a386_prefb1995 ... a
> 386_prefb2010
                             a387_prefb   ->   a387_prefb1990 a387_prefb1995 ... a
> 387_prefb2010
                             a388_prefb   ->   a388_prefb1990 a388_prefb1995 ... a
> 388_prefb2010
                             a389_prefb   ->   a389_prefb1990 a389_prefb1995 ... a
> 389_prefb2010
                             a390_prefb   ->   a390_prefb1990 a390_prefb1995 ... a
> 390_prefb2010
                             a391_prefb   ->   a391_prefb1990 a391_prefb1995 ... a
> 391_prefb2010
                             a392_prefb   ->   a392_prefb1990 a392_prefb1995 ... a
> 392_prefb2010
                             a393_prefb   ->   a393_prefb1990 a393_prefb1995 ... a
> 393_prefb2010
                             a394_prefb   ->   a394_prefb1990 a394_prefb1995 ... a
> 394_prefb2010
                             a395_prefb   ->   a395_prefb1990 a395_prefb1995 ... a
> 395_prefb2010
                             a396_prefb   ->   a396_prefb1990 a396_prefb1995 ... a
> 396_prefb2010
                             a397_prefb   ->   a397_prefb1990 a397_prefb1995 ... a
> 397_prefb2010
                             a398_prefb   ->   a398_prefb1990 a398_prefb1995 ... a
> 398_prefb2010
                             a399_prefb   ->   a399_prefb1990 a399_prefb1995 ... a
> 399_prefb2010
                             a400_prefb   ->   a400_prefb1990 a400_prefb1995 ... a
> 400_prefb2010
                             a401_prefb   ->   a401_prefb1990 a401_prefb1995 ... a
> 401_prefb2010
                             a402_prefb   ->   a402_prefb1990 a402_prefb1995 ... a
> 402_prefb2010
                             a403_prefb   ->   a403_prefb1990 a403_prefb1995 ... a
> 403_prefb2010
                             a404_prefb   ->   a404_prefb1990 a404_prefb1995 ... a
> 404_prefb2010
                             a405_prefb   ->   a405_prefb1990 a405_prefb1995 ... a
> 405_prefb2010
                             a406_prefb   ->   a406_prefb1990 a406_prefb1995 ... a
> 406_prefb2010
                             a407_prefb   ->   a407_prefb1990 a407_prefb1995 ... a
> 407_prefb2010
                             a408_prefb   ->   a408_prefb1990 a408_prefb1995 ... a
> 408_prefb2010
                             a409_prefb   ->   a409_prefb1990 a409_prefb1995 ... a
> 409_prefb2010
                             a410_prefb   ->   a410_prefb1990 a410_prefb1995 ... a
> 410_prefb2010
                             a411_prefb   ->   a411_prefb1990 a411_prefb1995 ... a
> 411_prefb2010
                             a412_prefb   ->   a412_prefb1990 a412_prefb1995 ... a
> 412_prefb2010
                             a413_prefb   ->   a413_prefb1990 a413_prefb1995 ... a
> 413_prefb2010
                             a414_prefb   ->   a414_prefb1990 a414_prefb1995 ... a
> 414_prefb2010
                             a415_prefb   ->   a415_prefb1990 a415_prefb1995 ... a
> 415_prefb2010
                             a416_prefb   ->   a416_prefb1990 a416_prefb1995 ... a
> 416_prefb2010
                             a417_prefb   ->   a417_prefb1990 a417_prefb1995 ... a
> 417_prefb2010
                             a418_prefb   ->   a418_prefb1990 a418_prefb1995 ... a
> 418_prefb2010
                             a419_prefb   ->   a419_prefb1990 a419_prefb1995 ... a
> 419_prefb2010
                             a420_prefb   ->   a420_prefb1990 a420_prefb1995 ... a
> 420_prefb2010
                             a421_prefb   ->   a421_prefb1990 a421_prefb1995 ... a
> 421_prefb2010
                             a422_prefb   ->   a422_prefb1990 a422_prefb1995 ... a
> 422_prefb2010
                             a423_prefb   ->   a423_prefb1990 a423_prefb1995 ... a
> 423_prefb2010
                             a424_prefb   ->   a424_prefb1990 a424_prefb1995 ... a
> 424_prefb2010
                             a425_prefb   ->   a425_prefb1990 a425_prefb1995 ... a
> 425_prefb2010
                             a426_prefb   ->   a426_prefb1990 a426_prefb1995 ... a
> 426_prefb2010
                             a427_prefb   ->   a427_prefb1990 a427_prefb1995 ... a
> 427_prefb2010
                             a428_prefb   ->   a428_prefb1990 a428_prefb1995 ... a
> 428_prefb2010
                             a432_prefb   ->   a432_prefb1990 a432_prefb1995 ... a
> 432_prefb2010
                             a433_prefb   ->   a433_prefb1990 a433_prefb1995 ... a
> 433_prefb2010
                             a435_prefb   ->   a435_prefb1990 a435_prefb1995 ... a
> 435_prefb2010
                             a436_prefb   ->   a436_prefb1990 a436_prefb1995 ... a
> 436_prefb2010
                             a438_prefb   ->   a438_prefb1990 a438_prefb1995 ... a
> 438_prefb2010
                             a439_prefb   ->   a439_prefb1990 a439_prefb1995 ... a
> 439_prefb2010
                             a440_prefb   ->   a440_prefb1990 a440_prefb1995 ... a
> 440_prefb2010
                             a441_prefb   ->   a441_prefb1990 a441_prefb1995 ... a
> 441_prefb2010
                             a442_prefb   ->   a442_prefb1990 a442_prefb1995 ... a
> 442_prefb2010
                             a443_prefb   ->   a443_prefb1990 a443_prefb1995 ... a
> 443_prefb2010
                             a444_prefb   ->   a444_prefb1990 a444_prefb1995 ... a
> 444_prefb2010
                             a445_prefb   ->   a445_prefb1990 a445_prefb1995 ... a
> 445_prefb2010
                             a447_prefb   ->   a447_prefb1990 a447_prefb1995 ... a
> 447_prefb2010
                             a448_prefb   ->   a448_prefb1990 a448_prefb1995 ... a
> 448_prefb2010
                             a450_prefb   ->   a450_prefb1990 a450_prefb1995 ... a
> 450_prefb2010
                             a452_prefb   ->   a452_prefb1990 a452_prefb1995 ... a
> 452_prefb2010
                        gdp_predf_prefb   ->   gdp_predf_prefb1990 gdp_predf_prefb
> 1995 ... gdp_predf_prefb2010
                        gdp_predc_prefb   ->   gdp_predc_prefb1990 gdp_predc_prefb
> 1995 ... gdp_predc_prefb2010
                  gdp_sect2_predf_prefb   ->   gdp_sect2_predf_prefb1990 gdp_sect2
> _predf_prefb1995 ... gdp_sect2_predf_prefb2010
                  gdp_sect2_predc_prefb   ->   gdp_sect2_predc_prefb1990 gdp_sect2
> _predc_prefb1995 ... gdp_sect2_predc_prefb2010
-----------------------------------------------------------------------------

. 
. foreach X of varlist gdp_prefb1990-gdp_sect2_predc_prefb2010 {
  2.         qui: sum `X'
  3.          if r(N)==0 {
  4.          drop `X'
  5.         }
  6. }

. 
. sort city05

. save prefb.dta, replace
(note: file prefb.dta not found)
file prefb.dta saved

. 
. 
. *********************** 6. Put All Data Sets Together **************************
> *
. 
. sort city05

. merge city05 using cp90a.dta
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          3 |        286      100.00      100.00
------------+-----------------------------------
      Total |        286      100.00

. drop _merge

. sort city05

. merge city05 using cp90.dta
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         18        6.29        6.29
          3 |        268       93.71      100.00
------------+-----------------------------------
      Total |        286      100.00

. drop _merge

. sort city05

. merge city05 using prefa.dta
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          3 |        286      100.00      100.00
------------+-----------------------------------
      Total |        286      100.00

. drop _merge

. sort city05

. merge city05 using pref.dta
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          3 |        286      100.00      100.00
------------+-----------------------------------
      Total |        286      100.00

. drop _merge

. sort city05

. merge city05 using ..\..\data\census\generated\card-inst.dta
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          3 |        286      100.00      100.00
------------+-----------------------------------
      Total |        286      100.00

. drop _merge

. rename city05 cc05

. sort cc05

. merge cc05 using ..\..\data\tabular_data_BJ\source\bus_trolley1991.dta
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          3 |        286      100.00      100.00
------------+-----------------------------------
      Total |        286      100.00

. drop _merge

. 
. *** Merge on GDP Deflators
. gen province05 = int(cc05/10000)

. sort province05

. merge province05 using ../../data/tabular_data_BJ/source/gdpdeflator_3years.dta
(note: you are using old merge syntax; see [D] merge for new syntax)
variable province05 does not uniquely identify observations in the master data

. tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          2 |          5        1.72        1.72
          3 |        286       98.28      100.00
------------+-----------------------------------
      Total |        291      100.00

. ** Provinces outside of our study area
. drop if _merge==2
(5 observations deleted)

. drop _merge

. sort cc05

. merge cc05 using ../../data/tabular_data_BJ/source/gdpdeflator_2010.dta
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          3 |        286      100.00      100.00
------------+-----------------------------------
      Total |        286      100.00

. drop _merge

. 
. ** Drop 2008 variables
. drop *2008

. drop if cc05==0|cc05==.
(0 observations deleted)

. 
. ** Merge on employment census data
. sort cc05

. merge cc05 using ..\..\data\empcensus\generated\emp_count_newind.dta
(note: you are using old merge syntax; see [D] merge for new syntax)

. tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          3 |        286      100.00      100.00
------------+-----------------------------------
      Total |        286      100.00

. drop _merge

. 
. 
. 
. *************************** 7. Label Variables *************************
. 
. foreach loc in cp90a cp90 pref prefa prefb {
  2. foreach yr in 1982 1990 1995 2000 2005 2010 {
  3. 
. cap label variable gdp_`loc'`yr' "(ind yrbk)"
  4. cap label variable nnp_`loc'`yr' "(ind yrbk)"
  5. cap label variable gdp_sector1_`loc'`yr' "(ind yrbk)"
  6. cap label variable nnp_sector1_`loc'`yr' "(ind yrbk)"
  7. cap label variable gdp_sector2_`loc'`yr' "(ind yrbk)"
  8. cap label variable nnp_sector2_`loc'`yr' "(ind yrbk)"
  9. cap label variable gdp_sector3_`loc'`yr' "(ind yrbk)"
 10. cap label variable nnp_sector3_`loc'`yr' "(ind yrbk)"
 11. cap label variable tot_pop_`loc'`yr' "(ind yrbk)"
 12. cap label variable r08_gdp_`loc'`yr' "(ind yrbk)"
 13. cap label variable r08_gdp_sector2_`loc'`yr' "(ind yrbk)"
 14. cap label variable r08_nnp_sector2_`loc'`yr' "(ind yrbk)"
 15. cap label variable r08_gdp_sector3_`loc'`yr' "(ind yrbk)"
 16. cap label variable r08_nnp_sector3_`loc'`yr' "(ind yrbk)"
 17. cap label variable r08_tot_pop_`loc'`yr' "(ind yrbk)"
 18. cap label variable arrived_fdi_`loc'`yr' "(ind yrbk)"
 19. cap label variable tot_emp_`loc'`yr' "(ind yrbk)"
 20. cap label variable tot_emp_sect2_`loc'`yr' "(ind yrbk)"
 21. cap label variable tot_emp_sect3_`loc'`yr' "(ind yrbk)"
 22. cap label variable num_car_`loc'`yr' "(ind yrbk)"
 23. cap label variable dust_ems_`loc'`yr' "(ind yrbk)"
 24. cap label variable so2_`loc'`yr' "(ind yrbk)"
 25. cap label variable giov_`loc'`yr' "(ind yrbk)"
 26. cap label variable giov_soecol_`loc'`yr' "(ind yrbk)"
 27. cap label variable tot_area_`loc'`yr' "(ind yrbk)"
 28. cap label variable giov_new_`loc'`yr' "(ind yrbk)"
 29. cap label variable giov_soecol_new_`loc'`yr' "(ind yrbk)"
 30. cap label variable agr_mp_`loc'`yr' "Total Agricultural Machinery Power (1000
> 0 Kw) (Michigan)"
 31. cap label variable pop_`loc'`yr' "Population at Year-end (10000 persons) (Mic
> higan)"
 32. cap label variable ruralpop_`loc'`yr' "Rural Population at yr end (10000 pers
> ons) (Michigan)"
 33. cap label variable rurallabor_`loc'`yr' "Number of rural laborers (10000 pers
> ons) (Michigan)"
 34. cap label variable gdp_michigan_`loc'`yr' "gdp (100 millian yuan) (Michigan)"
 35. cap label variable gdp_sector2_mi_`loc'`yr' "gdp Sector 2 (100 millian yuan) 
> (Michigan)"
 36. cap label variable gdp_sector3_mi_`loc'`yr' "gdp Sector 3 (100 millian yuan) 
> (Michigan)"
 37. cap label variable va_sec1_`loc'`yr' "Value Added of Primary Industry (100 mi
> llion yuan) (Michigan)"
 38. cap label variable va_sec2_`loc'`yr' "Value Added of Secondary Industry (100 
> million yuan) (Michigan)"
 39. cap label variable expval_`loc'`yr' "Value of Exports (1,000 US Dollars) (Mic
> higan)"
 40. cap label variable totemp_`loc'`yr' " (py)"
 41. cap label variable gdp_py_`loc'`yr' " (py)"
 42. cap label variable gdp_sect2_`loc'`yr' " (py)"
 43. cap label variable gdp_sect3_`loc'`yr' " (py)"
 44. cap label variable total_pop_`loc'`yr' " (py)"
 45. cap label variable kmpr_`loc'`yr' " (py)"
 46. cap label variable apr_`loc'`yr' " (py)"
 47. cap label variable prpc_`loc'`yr' " (py)"
 48. cap label variable num_bt_`loc'`yr' " (py)"
 49. cap label variable avgsalary_`loc'`yr' " (py)"
 50. cap label variable num_colstd_`loc'`yr' " (py)"
 51. cap label variable givo_py_`loc'`yr' " (py)"
 52. cap label variable givo_soe_`loc'`yr' " (py)"
 53. cap label variable givo_colt_`loc'`yr' " (py)"
 54. cap label variable exp_lgt_`loc'`yr' " (py)"
 55. cap label variable num_hedu_`loc'`yr' " (py)"
 56. cap label variable publibcol_`loc'`yr' " (py)"
 57. cap label variable culland_`loc'`yr' " (py)"
 58. cap label variable area_`loc'`yr' " (py)"
 59. cap label variable emp_sect2_`loc'`yr' " (py)"
 60. cap label variable emp_sect3_`loc'`yr' " (py)"
 61. cap label variable fixinvest_`loc'`yr' " (py)"
 62. cap label variable fdi_py_`loc'`yr' " (py)"
 63. cap label variable a101_`loc'`yr' "Total no. of H                            
>                 Table 2-19"
 64. cap label variable a102_`loc'`yr' "Total P                                   
>                          "
 65. cap label variable a103_`loc'`yr' "Total M                                   
> H=household(s)           "
 66. cap label variable a104_`loc'`yr' "Total F                                   
> M=male(s)                "
 67. cap label variable a105_`loc'`yr' "Residents of urban wards: No. of H        
> F=female(s)              "
 68. cap label variable a106_`loc'`yr' "                     : P               P=p
> opulation (M+F)       "
 69. cap label variable a107_`loc'`yr' "                     : M                  
>                       "
 70. cap label variable a108_`loc'`yr' "                     : F                  
>                       "
 71. cap label variable a109_`loc'`yr' "Residents of villages: No. of H           
>                          "
 72. cap label variable a110_`loc'`yr' "                  : P                     
>                       "
 73. cap label variable a111_`loc'`yr' "                  : M                     
>                       "
 74. cap label variable a112_`loc'`yr' "                  : F                     
>                       "
 75. cap label variable a113_`loc'`yr' "Residents of rural units outside village j
> urisdiction: No. of H    "
 76. cap label variable a114_`loc'`yr' "                                          
>         : P           "
 77. cap label variable a115_`loc'`yr' "                                          
>         : M           "
 78. cap label variable a116_`loc'`yr' "                                          
>         : F           "
 79. cap label variable a117_`loc'`yr' "Non-agricultural H: P                     
>                          "
 80. cap label variable a118_`loc'`yr' "               : M                        
>                       "
 81. cap label variable a119_`loc'`yr' "               : F                        
>                       "
 82. cap label variable a120_`loc'`yr' "Agricultural H: P                         
>                          "
 83. cap label variable a121_`loc'`yr' "           : M                            
>                       "
 84. cap label variable a122_`loc'`yr' "           : F                            
>                       "
 85. cap label variable a123_`loc'`yr' "Specially designated H and persons outside
>  any H: P                "
 86. cap label variable a124_`loc'`yr' "                                          
>    : M                "
 87. cap label variable a125_`loc'`yr' "                                          
>    : F                "
 88. cap label variable a126_`loc'`yr' "All residents of all zhen (townships) comb
> ined: No. of H  Table 2-11"
 89. cap label variable a127_`loc'`yr' "                                       : P
>                   "
 90. cap label variable a128_`loc'`yr' "                                       : M
>                   "
 91. cap label variable a129_`loc'`yr' "                                       : F
>                   "
 92. cap label variable a130_`loc'`yr' "Town residents in all zhen combined: No. o
> f H                      "
 93. cap label variable a131_`loc'`yr' "                                 : P      
>                        "
 94. cap label variable a132_`loc'`yr' "                                 : M      
>                        "
 95. cap label variable a133_`loc'`yr' "                                 : F      
>                        "
 96. cap label variable a134_`loc'`yr' "Rural residents in all zhen combined: No. 
> of H                     "
 97. cap label variable a135_`loc'`yr' "                                  : P     
>                        "
 98. cap label variable a136_`loc'`yr' "                                  : M     
>                        "
 99. cap label variable a137_`loc'`yr' "                                  : F     
>                        "
100. cap label variable a138_`loc'`yr' "Non-agricultural H in all zhen combined: P
>                 Table 2-12"
101. cap label variable a139_`loc'`yr' "                                     : M  
>                        "
102. cap label variable a140_`loc'`yr' "                                     : F  
>                        "
103. cap label variable a141_`loc'`yr' "Agricultural H in all zhen combined: P    
>                          "
104. cap label variable a142_`loc'`yr' "                              : M         
>                     "
105. cap label variable a143_`loc'`yr' "                           : F            
>                     "
106. cap label variable a144_`loc'`yr' "Specially designated H, etc. in all zhen c
> ombined: P               "
107. cap label variable a145_`loc'`yr' "                                          
>   : M               "
108. cap label variable a146_`loc'`yr' "                                          
>   : F               "
109. cap label variable a181_`loc'`yr' "Total P, all ages and both sexes          
>                           A1"
110. cap label variable a182_`loc'`yr' "Total M, all ages                         
>                           A2"
111. cap label variable a183_`loc'`yr' "Total F, all ages                         
>                           A3"
112. cap label variable a184_`loc'`yr' "P 0-4                                     
>                           A4"
113. cap label variable a185_`loc'`yr' "M 0-4                                     
>                           A5"
114. cap label variable a186_`loc'`yr' "F 0-4                                     
>                           A6"
115. cap label variable a187_`loc'`yr' "P 5-9                                     
>                           A7"
116. cap label variable a188_`loc'`yr' "M 5-9                                     
>                           A8"
117. cap label variable a189_`loc'`yr' "F 5-9                                     
>                           A9"
118. cap label variable a190_`loc'`yr' "P 10-14                                   
>                          A10"
119. cap label variable a191_`loc'`yr' "M 10-14                                   
>                          A11"
120. cap label variable a192_`loc'`yr' "F 10-14                                   
>                          A12"
121. cap label variable a193_`loc'`yr' "P 15-19                                   
>                          A13"
122. cap label variable a194_`loc'`yr' "M 15-19                                   
>                          A14"
123. cap label variable a195_`loc'`yr' "F 15-19                                   
>                          A15"
124. cap label variable a196_`loc'`yr' "P 20-24                                   
>                          A16"
125. cap label variable a197_`loc'`yr' "M 20-24                                   
>                          A17"
126. cap label variable a198_`loc'`yr' "F 20-24                                   
>                          A18"
127. cap label variable a199_`loc'`yr' "P 25-29                                   
>                          A19"
128. cap label variable a200_`loc'`yr' "M 25-29                                   
>                          A20"
129. cap label variable a201_`loc'`yr' "F 25-29                                   
>                          A21"
130. cap label variable a202_`loc'`yr' "P 30-34                                   
>                          A22"
131. cap label variable a203_`loc'`yr' "M 30-34                                   
>                          A23"
132. cap label variable a204_`loc'`yr' "F 30-34                                   
>                          A24"
133. cap label variable a205_`loc'`yr' "P 35-39                                   
>                          A25"
134. cap label variable a206_`loc'`yr' "M 35-39                                   
>                          A26"
135. cap label variable a207_`loc'`yr' "F 35-39                                   
>                          A27"
136. cap label variable a208_`loc'`yr' "P 40-44                                   
>                          A28"
137. cap label variable a209_`loc'`yr' "M 40-44                                   
>                          A29"
138. cap label variable a210_`loc'`yr' "F 40-44                                   
>                          A30"
139. cap label variable a261_`loc'`yr' "Total P aged 6+                           
>                              E1"
140. cap label variable a262_`loc'`yr' "Total M aged 6+                           
>                              E1"
141. cap label variable a263_`loc'`yr' "Total F aged 6+                           
>                              E1"
142. cap label variable a264_`loc'`yr' "P university                              
>                           E4"
143. cap label variable a267_`loc'`yr' "P technical/junior college                
>                           E7"
144. cap label variable a270_`loc'`yr' "P secondary technical school              
>                          E10"
145. cap label variable a273_`loc'`yr' "P senior middle school                    
>                          E13"
146. cap label variable a276_`loc'`yr' "P junior middle school                    
>                          E16"
147. cap label variable a279_`loc'`yr' "P primary school                          
>                          E19"
148. cap label variable a361_`loc'`yr' "Total inmigrants                          
>                           R1"
149. cap label variable a362_`loc'`yr' "Within-province inmigrants: Total         
>                           R2"
150. cap label variable a363_`loc'`yr' "                       : from municipal ci
> ties                   R3"
151. cap label variable a364_`loc'`yr' "                       : from zhen (urban 
> townships)             R4"
152. cap label variable a365_`loc'`yr' "                       : from xiang (rural
>  townships)            R5"
153. cap label variable a366_`loc'`yr' "Inmigrants from other provinces: Total    
>                           R6"
154. cap label variable a367_`loc'`yr' "                         : from municipal 
> cities                 R7"
155. cap label variable a368_`loc'`yr' "                         : from zhen      
>                        R8"
156. cap label variable a369_`loc'`yr' "                         : from xiang     
>                        R9"
157. cap label variable a370_`loc'`yr' "Other inmigrants                          
>                          R10"
158. cap label variable a381_`loc'`yr' "Total employed P                          
>                           I1"
159. cap label variable a384_`loc'`yr' "P Agric./forestry/animal husb./fishery/wat
> er conservancy            I4"
160. cap label variable a387_`loc'`yr' "P Industry                                
>                           I7"
161. cap label variable a390_`loc'`yr' "P Mining, prospecting                     
>                          I10"
162. cap label variable a393_`loc'`yr' "P Construction                            
>                          I13"
163. cap label variable a396_`loc'`yr' "P Transport, posts, telecommunications    
>                          I16"
164. cap label variable a399_`loc'`yr' "P Commerce, supply and marketing          
>                          I19"
165. cap label variable a402_`loc'`yr' "P Real estate, utilities, residential serv
> ices                     I22"
166. cap label variable a405_`loc'`yr' "P Medicine, health care, sports, welfare  
>                          I25"
167. cap label variable a408_`loc'`yr' "P Education, culture, arts, radio, televis
> ion                      I28"
168. cap label variable a411_`loc'`yr' "P Science, technology                     
>                          I31"
169. cap label variable a414_`loc'`yr' "P Finance, insurance                      
>                          I34"
170. cap label variable a417_`loc'`yr' "P Government, party, and NGOs             
>                          I37"
171. cap label variable a420_`loc'`yr' "P Other economic activities               
>                          I40"
172. cap label variable a431_`loc'`yr' "P Professional and high-level technical pe
> rsonnel                   O1"
173. cap label variable a434_`loc'`yr' "P Officials/managers in gov't, party, busi
> ness, & NGOs              O4"
174. cap label variable a437_`loc'`yr' "P Clerical personnel                      
>                           O7"
175. cap label variable a440_`loc'`yr' "P Employees in commercial sector          
>                          O10"
176. cap label variable a443_`loc'`yr' "P Employees in service sector             
>                          O13"
177. cap label variable a446_`loc'`yr' "P Workers in agric., forestry, animal husb
> ., fisheries             O16"
178. cap label variable a449_`loc'`yr' "P Workers in manufacturing, construction, 
> transport, etc.          O19"
179. cap label variable a452_`loc'`yr' "P Other and misc. occupations             
>                          O22"
180. cap label variable c_totalPop_`loc'`yr'                                 "cens
> us total pop"
181. cap label variable c_emp_`loc'`yr'                  "census total emp"
182. cap label variable c_emp_ag_`loc'`yr'         " census agricultural emp"
183. cap label variable c_emp_min_`loc'`yr'       "census mining emp"
184. cap label variable c_emp_man_`loc'`yr'                      "census manufactu
> ring emp"
185. cap label variable c_emp_man_trad_`loc'`yr'           "census manu trad emp"
186. cap label variable c_emp_man_chem_`loc'`yr'        "census manu chem emp"
187. cap label variable c_emp_man_hvy_`loc'`yr'            "census manu heavy emp"
188. cap label variable c_emp_man_hitech_`loc'`yr'       "census manu hightech emp
> "
189. cap label variable c_emp_util_`loc'`yr'                         "census util 
> emp"
190. cap label variable c_emp_cons_`loc'`yr'                      "census cons emp
> "
191. cap label variable c_emp_soft_`loc'`yr'                       "census soft em
> p"
192. cap label variable c_emp_whsl_`loc'`yr'                      "census wholesal
> e emp"
193. cap label variable c_emp_fina_`loc'`yr'                        "census financ
> e emp"
194. cap label variable c_emp_res_`loc'`yr'                         "census res em
> p"
195. cap label variable c_emp_cul_`loc'`yr'                        "  census cul e
> mp"
196. cap label variable c_emp_pub_`loc'`yr'                       "census pub emp"
197. cap label variable c_emp_tran_`loc'`yr'                       "census transpo
> rtaion emp"
198. cap label variable c_rur_Mig_`loc'`yr'           "census rural migrant"
199. cap label variable c_urb_Mig_`loc'`yr'          "census urban migrant"
200. cap label variable c_rur_mig_19to55__`loc'`yr'        "census rural migrant 1
> 9-55"
201. cap label variable c_rur_mig_19to55_h_`loc'`yr'      "census rural migrant 19
> -55 high"
202. cap label variable c_urb_mig_19to55__`loc'`yr'       "census urban migrant 19
> -55"
203. cap label variable c_urb_mig_19to55_h_`loc'`yr'     "census urban migrant 19-
> 55 high"
204. cap label variable c_f_19to55_`loc'`yr'                         "census femal
> e 19-55"
205. cap label variable c_f_Under19_`loc'`yr'                     "census female <
> 19"
206. cap label variable c_f_Over55_`loc'`yr'                        "census female
>  >55"
207. cap label variable c_f_19to55_h_`loc'`yr'                    "census female 1
> 9-55 high"
208. cap label variable c_f_19to55_w__`loc'`yr'                "census female 19-5
> 5 work"
209. cap label variable c_f_19to55_w_h_`loc'`yr'                              "cen
> sus female 19-55 work high"
210. cap label variable c_f_19to55_w_c_`loc'`yr'                              "cen
> sus female 19-55 work college"
211. cap label variable c_m_19to55_`loc'`yr'      "census male 19-55"
212. cap label variable c_m_Under19_`loc'`yr'                   "census male <19"
213. cap label variable c_m_Over55_`loc'`yr'                      "census male >55
> "
214. cap label variable c_m_19to55_h_`loc'`yr'                  "census male 19-55
>  high"
215. cap label variable c_m_19to55_w__`loc'`yr'                              "cens
> us male 19-55 work"
216. cap label variable c_m_19to55_w_h_`loc'`yr'           "census male 19-55 work
>  high"
217. cap label variable c_m_19to55_w_c_`loc'`yr'            "census male 19-55 wor
> k college"
218. cap label variable c_rur_mig_A_`loc'`yr'                      "census rural m
> igrantA"
219. cap label variable c_urb_mig_A_`loc'`yr'                     "census urban mi
> grant A"
220. cap label variable c_rur_mig_19to55_A_`loc'`yr'     "census rural migrant 19-
> 55 A"
221. cap label variable c_rur_mig_19to55_h_A_`loc'`yr'    "census rural migrant 19
> -55 high A"
222. cap label variable c_urb_mig_19to55_A_`loc'`yr'    "census urban migrant 19-5
> 5 A"
223. cap label variable c_urb_mig_19to55_h_A_`loc'`yr'               "census urban
>  migrant 19-55 high A"
224. cap label variable c_rur_ob__`loc'`yr'                           "census rura
> l out birth"
225. cap label variable c_urb_ob__`loc'`yr'                          "census urban
>  out birth"
226. cap label variable c_rur_ob_19to55__`loc'`yr'          "census rural out birt
> h 19-55"
227. cap label variable c_rur_ob_19to55_h_`loc'`yr'        "census rural out birth
>  19-55 high"
228. cap label variable c_urb_ob_19to55__`loc'`yr'         "census urban out birth
>  19-55"
229. cap label variable c_urb_ob_19to55_h_`loc'`yr'       "census urban out birth 
> 19-55 high"
230. cap label variable c_rur_ob_A1_`loc'`yr'                     "census rural ou
> t birth A1"
231. cap label variable c_urb_ob_A1_`loc'`yr'                    "census urban out
>  birth A1"
232. cap label variable c_rur_ob_19to55_A1_`loc'`yr'     "census rural out birth 1
> 9-55 A1"
233. cap label variable c_rur_ob_19to55_h_A1_`loc'`yr'                "census rura
> l out birth 19-55 high A1"
234. cap label variable c_urb_ob_19to55_A1_`loc'`yr'    "census urban out birth 19
> -55 A1"
235. cap label variable c_urb_ob_19to55_h_A1_`loc'`yr'               "census urban
>  out birth 19-55 high A1"
236. cap label variable c_rur_ob_A2_`loc'`yr'                     "census rural ou
> t birth A2"
237. cap label variable c_urb_ob_A2_`loc'`yr'                    "census urban out
>  birth A2"
238. cap label variable c_rur_ob_19to55_A2_`loc'`yr'     "census rural out birth 1
> 9-55 A2"
239. cap label variable c_rur_ob_19to55_h_A2_`loc'`yr'                "census rura
> l out birth 19-55 high A2"
240. cap label variable c_urb_ob_19to55_A2_`loc'`yr'    "census urban out birth 19
> -55 A2"
241. cap label variable c_urb_ob_19to55_h_A2_`loc'`yr'               "census urban
>  out birth 19-55 high A2"
242. cap label variable actpop_`loc'`yr'  "census population from 2010 aggregate d
> ata"
243. }
244. }

. 
. sort cc05

. save ..\..\data\tabular_data_BJ\generated\combined.dta, replace
file ..\..\data\tabular_data_BJ\generated\combined.dta saved

. 
. 
. log close
      name:  <unnamed>
       log:  C:\research\china\decentralization\restat_data\tabdata\dofiles\tab_da
> ta\tabdata6.log
  log type:  text
 closed on:  22 Jul 2016, 09:51:40
----------------------------------------------------------------------------------
